Kbase P109010: How to calculate the most appropriate value for -Bt in OpenEdge 10.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/03/2009 |
|
Status: Verified
GOAL:
How to calculate the most appropriate value for -Bt in OpenEdge 10.
FACT(s) (Environment):
OpenEdge 10.x
All Supported Operating Systems
FIX:
When working with temp-tables it is best to keep as much in memory as possible.
The -Bt is used to allocate memory for Buffers for Temp-Tables.
The minimum value for -Bt is 10.
The default value prior to 10.1A was 10. In 10.1A and later the default is 255.
The following algorithm is a simplistic version of what is done in the client code.
A good basic method to calculate a close value for -Bt during the development phase:
<# of temp-tables in use at one time> * 9
Example:
If the application has 10 temp tables defined but only 5 are active at any one time then the following would a good setting for -Bt.
-Bt = 5 * 9
An alternate method typically used after deployment, especially useful if access to the source code is not possible, is to monitor the size of the DBI file created by the client.
The formula for this method would be:
DBI size (in KB) * 1024 / -tmpbsize (1 for 1024 or 8 for 8192) = new value for -Bt.
Note: In 10.1B the default tmpbsize was increased from 1K to 4K.