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

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 Blocksin 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.