Kbase 15217: How do you get the CACHE option on DEFINE QUERY to work?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How do you get the CACHE option on DEFINE QUERY to work?
The purpose of the CACHE option is to retain local copies of the
most recently read records of the query. The copies are kept in
the client's record buffer pool.
This mechanism can sometimes speed up browsing when GET PREVIOUS and
GET NEXT requests are used repeatedly to move back and forth. The
cache has little impact if you only scroll forward through the
query result set.
Progress Software Technical Support Note # 15217