Kbase P3781: Slow Performances with the IN-LIST Function within Report Bu
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
Slow Performances with the IN-LIST Function within Report Builder
CAUSE:
When you use the IN-LIST function in RB it generates SQL which doesn't use an index. Instead it searches the whole table for every item in the list. This makes this function unusable in situations where you have a large DB with lots of records.
FIX:
Increasing the -TB parameter and -TM parameter cut the processing time in half.
-TB and -TM are Client Connection Startup Parameters.
-TB Speed Sort. Minimum value 1, Maximum value 31.
-TM Merge Number. Minimun value 1, Maximum value 32.