Kbase 16217: browse column search uses query result list NO INDEX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/02/2000 |
|
browse column search uses query result list NO INDEX
The column search feature of the browse (Version 8 and later) uses a
results-list. It will not, by default, use any index. If a match is
found in the currently-cached result list, no further database access
is needed. However, if no matches are currently in the result list,
the column search will continue to fetch records into the result list
until a match is found.
If a large result set is anticipated, the 4GL developer should
add a trigger block on the START-SEARCH event to do a FIND FIRST
(which will use an index) and then REPOSITION the query to
the ROWID of the returned record. In a large query, this will
provide a significant performance gain.
See related KBase entries:
14157 How to override default search in Updatable Browse ( v8 )
15197 How to override default search in Browse
Progress Software Technical Support Note # 16217