Kbase P50928: SQL-92: Including array fields in the result set of a SELECT statement causes the degradation of per
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
31/01/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Including array fields in the result set of a SELECT statement causes the degradation of performance after installing Service Pack 5, 6 or 7 for 9.1D.
The SQL-Width for each array field is set to a high number, e.g. 1440.
Each array field consists of a high amount of extents, e.g. 36.
CAUSE:
Bug# 20031024-009
CAUSE:
The high value of the SQL-Width is causing the performance problem.
FIX:
Upgrade to 9.1D SP8 or later.
- OR-
Lower the SQL-Width until an acceptable performance is achieved.
You can put this to a very low value (e.g. 100) and use DBTool to adjust the width automatically. After this increase the value to account for future expansion of the fields.