Kbase P176287: Why can static and dynamic queries perform poorly when repositioning?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/28/2010 |
|
Status: Unverified
GOAL:
Why does the REPOSITION-TO-ROWID method perform poorly with a dynamic query?
GOAL:
Why does the REPOSITION-TO-ROW method perform poorly with a dynamic query?
GOAL:
Why do dynamic queries seem to perform slowly during repositions?
GOAL:
Why does the REPOSITION statement perform poorly with a static query?
GOAL:
Why do static queries seem to perform slowly during repositions?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
FIX:
Queries (both dynamic and static) by default do not use the INDEXED-REPOSITION option. This option is used to optimize reposition statements but is not set by default because it can impact an application due to the fact that using INDEXED-REPOSITION causes the client side result set to be thrown away and rebuilt.
To obtain greater performance in a dynamic query simply add the phrase "INDEXED-REPOSITION" to your QUERY-PREPARE string.
To obtain greater performance in a static query simply add the phrase "INDEXED-REPOSITION" to the OPEN QUERY statement.