Kbase 15732: Queries appear to hang after conversion from V6 to V7
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Queries appear to hang after conversion from V6 to V7
SYMPTOM:
Users complain that queries are taking an extremely long time to
complete in Version 7 in comparison to the same queries in Version 6.
The screen appears to be hung.
WHAT TO LOOK FOR:
Check the syntax of the query code. If the query is structured using
the following syntax, you need to change the syntax to improve the
performance.
FIND <table> WHERE RECID(<table>) = <recid> USE-INDEX <index>.
In Version 7, when both RECID and USE-INDEX are contained in the
query statement, PROGRESS uses the index to perform the query. This
means that the query is processed by doing a sequential search on the
table instead of using the RECID to find the record immediately.
HOW TO OPTIMIZE THE QUERY:
The way to resolve the "hang" and optimize the query is to allow
PROGRESS to use the RECID. This is done by removing the USE-INDEX
qualifier from the query statement.
09-May-96
Progress Software Technical Support Note # 15732