Number of Buffers for Temporary Tables (-Bt)
- Last Updated: January 17, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
Use Number of Buffers for Temporary Tables (-Bt) to specify the number of
buffers in the temporary table database pool.
| Operating system and syntax | UNIX / Windows |
-Bt
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Session | 100,000,000 (64-bit OpenEdge) 12,500,000 ( 32-bit OpenEdge) | 10 | 255 | 255 |
- n
- An integer that specifies the number of blocks in the buffer for
temporary tables.
OpenEdge uses the value you specify for temporary databases used during the session the same way it uses Blocks in Database Buffers (-B) for permanent databases. The default value is 255.
Use Temporary Table Database Block Size (-tmpbsize) to specify the temporary table database block size, which dictates the size of each buffer in the temporary table database buffer pool for the current OpenEdge session.
If you do not have enough free memory (virtual or physical) for the buffer pool, reduce the
value of -Bt. To approximate the amount of memory required (in kilobytes)
for the buffer pool, use the following formula:
|
See Develop ABL Applications for more information about temporary tables.