Temporary Table Database Block Size (-tmpbsize)

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

An INTEGER that 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.

Note: With the changes made in Release 10.1B to provide support for expanded keys and temp-tables, the default block size for temp-tables has increased from a 1KB block size to a 4KB block size on all platforms. If you are creating very small temp-tables, you might notice a performance degradation with this change.

See OpenEdge Getting Started: ABL Essentials for more information on temp-tables.