Kbase P81415: Undocumented RB startup parameter to improve performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/07/2009 |
|
Status: Unverified
GOAL:
Undocumented RB startup parameter to improve performance
GOAL:
How to improve perfromances with Report Builder?
GOAL:
Improving performances with Report Builder
FIX:
The SQL Engine, which processes the SQL in a report, will sometimes change the order in which the tables are specified in the From Clause of the Select.
This is done in an attempt to optimize the SQL Select statement,however, sometimes it has the opposite effect.
There is a new option in Report builder to fix this. See KB- 18172 .
Some people may opt for using a startup parameter instead of this option in Report Builder. This undocumented startup parameter is -noreorder .
The -noreorder startup parameter is passed to the SQL engine. It overrides the menu option. If you start RB with -noreorder, the setting of the No Join Reorder menu option doesn't matter; the report will be run without the join optimization.
-noreorder does not affect what is stored in the report. The current setting of the menu option is what is stored in the report when you save it. So starting RB with -noreorder and saving a report without No Join Reorder checked will not turn on No Join reorder in the saved report.
This Parameter can be run from the rbstart.pf or startup.pf files as well as in the line where you initally start your Progress session. For more information about these files please read Report Builder Admin Guide Section A.2.1 Using Parameters When Starting Report Builder.