Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : Number of Buffers for Temporary Tables (-Bt)
 

Number of Buffers for Temporary Tables (-Bt)

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
50,000
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:
1.1 * (the value of -Bt) * (the value of -tmpbsize)
See OpenEdge Getting Started: ABL Essentials for more information on temporary tables.