Kbase 18371: What is the size of a Temporary Table (-Bt) Buffer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/06/2003 |
|
Solution ID: 18371
GOAL:
What is the size of a Temporary Table (-Bt) Buffer?
FIX:
The -Bt is a client startup parameter used to determine the number of blocks allocated for a temporary table database. In some cases, increasing this value may improve performance of applications that are working with temporary tables.
The -Bt parameter size is directly related to the Operating System blocksize and therefore, varies between platforms.
OS Block size
-------------------------- ------------
Windows (all flavours) 4Kb
Unix (all flavours) 1Kb
AS400 (Native 4GL Client
and AppServer) 2Kb