Kbase P114221: Poor performance rendering application unusable when executing SQL join query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/19/2006 |
|
Status: Verified
FACT(s) (Environment):
OpenEdge 10.0B
OpenEdge 10.1A
SYMPTOM(s):
Poor performance rendering application unusable
Executing SQL-92 join query
Sometimes the result set is never returned
The machine hangs since all the system CPU is used
Using the "{no reorder}" option improves the performance significantly.
CAUSE:
Bug# 20060301-023
FIX:
Upgrade to OpenEdge 10.0B05 or later
Upgrade to OpenEdge 10.1A01 or later.
If upgrading is not possible, adding the {no reorder} option in the query at the end of the FROM allows to improve performance.