Kbase P43350: Progress 9.1D07 service pack provides enhanced performance for temp tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Progress 9.1D07 service pack provides enhanced performance for temp tables
GOAL:
How can I change the block size for temp tables?
GOAL:
Modifications on temp table behavior introduced with Progress 9.1D service pack 7
FACT(s) (Environment):
Progress 9.1D
UNIX
Windows
FIX:
With the release of Progress 9.1D service pack 7, the overall performance of 4GL temp tables has been enhanced. A new client startup parameter, -tmpbsize, can now be used to identify the temp table block size for each client session. Possible values for the new client startup parameter include 1 and 8, which set the temp table block size to 1024 and 8192 respectively. The default value is 1. We suggest this default setting as we believe this will be the most efficient setting for *most* Progress 4GL applications.
Examples:
-tmpbsize 1
-tmpbsize 8
In addition to the -tmpbsize client startup parameter, the value of the -Bt client startup parameter has changed. Previously, the value specified was in "kilobyte" units. This value has now been changed to the "number of buffers", which is consistent with the value used with the -B database startup parameter.