Kbase P152479: Periodic performance hit when instantiating and deleting many temp-tables in a loop
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/09/2009 |
|
Status: Unverified
SYMPTOM(s):
ABL Class defines private temp-table
Test program loops 1,000 times instantiating a new class instance each time while storing the instantiated object in a temp-table
Normal execution time for 1,000 iterations is 450 to 500 milliseconds
Periodically the execution time jumps to between 1,400 and 4,000 milliseconds
FACT(s) (Environment):
OpenEdge 10.1C
All Supported Operating Systems
OpenEdge 10.2A
CAUSE:
The periodic jumps in execution time are caused by normal temp-table database management (i.e. buffer pool reads/write and general management overhead)
FIX:
This is normal behavior and is expected. Increasing the -Bt startup parameter may alleviate some of the periodic performance hit (or at least lengthen the amount of time before it happens).