Kbase P22566: Report Builder performance tuning tips?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/7/2003 |
|
Status: Unverified
GOAL:
Some Report Builder query performance tuning tips?
FACT(s) (Environment):
Windows
FACT(s) (Environment):
Progress 8.x
FACT(s) (Environment):
Progress 9.x
FIX:
In some Report Builder queries, the Progress SQL optimizer reorders the tables in the From clause of the Select statement causing the SQL Engine to process larger tables first making the query slower.
In such cases, using the ·NO JOIN REORDER· option or the -rbexpjoins startup parameter may help reports run faster.
1. Using the ·NO JOIN REORDER· option of the Report Builder allows the user to specify that they do not want the order of the tables changed.
If the menu item Database->NO JOIN REORDER is checked, the SQL Engine will NOT change the order of the tables. To activate this option, select it and re-save the report.
This option may help increase performance on reports that contain SQL using the implicit join syntax. This option will have no effect when used with the -rbexpjoins (The Explicit Join) Report Builder startup parameter.
2. Use the -rbexpjoins (The Explicit Join) Report Builder startup parameter. This parameter allows you to use explicit inner join syntax rather than the default implicit syntax. When explicit syntax is used, the behavior of the optimizer in the SQL Engine is altered. There are cases when this can be beneficial depending upon the amount of data, size of records, and the structure of the SQL query.