Temporary Table Database Block Size (-tmpbsize)
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Use Temporary Table Database Block Size (-tmpbsize) to specify the
temp-table block size.
| Operating system and syntax | UNIX / Windows |
-tmpbsize
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Session | — | — | 4 | 4 |
- n
- An
INTEGERthat specifies the temp-table database block size. Valid values are:- 1—Sets the block size to 1024 bytes.
- 4—Sets the block size to 4096 bytes. This is the default value.
- 8—Sets the block size to 8192 bytes.
The temp-table database block size dictates the size of each buffer in the temp-table database buffer pool for the current OpenEdge session.
Use Number of Buffers for Temporary Tables (-Bt) to specify the number of buffers in the temp-table database buffer pool.
See Develop ABL Applications for more information about temp-tables.