Kbase P13503: Heavy use of temp-tables by constantly passing them from procedure to procedure slows performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/01/2009 |
|
Status: Verified
SYMPTOM(s):
Performance is slower in Progress 9.x
Very heavy use is made of temp-tables
Temp-tables are passed from procedure to procedure
FACT(s) (Environment):
Progress 9.1D
Sun Solaris SPARC
CHANGE:
Moved from Progress 8.3 to Progress 9.1
CAUSE:
Temp-tables are being passed from procedure to procedure constantly and this is causing greater performance degradation in Progress 9.x than in Progress 8.3
FIX:
Modify the application code so that temp-tables are passed by handle instead of passing the entire temp-table.