Kbase 19119: Undocumented RB Startup Parameter to Improve Performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/08/2003 |
|
Status: Unverified
FACT(s) (Environment):
Report Builder
Progress 8.3x
SYMPTOM(s):
SYSTEM ERROR: Cannot insert a key of size <key-size> into a sort buffer of size <buffer-size>. (4219)
-noreorder
CAUSE:
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.
FIX:
Some people may opt for using a startup parameter 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.