CacheLimit (ODBCResultSet - LotusScript)
Read-write. The maximum number of rows to be cached in memory.
Defined in
Data type
Long
Syntax
To get: limit& = odbcResultSet .CacheLimit
To set: odbcResultSet .CacheLimit = limit&
Usage
The limit is DB_ALL (full set), DB_NONE (minimum set), or the number of rows to store. DB_NONE means that only a very small window, including the current row, is kept in memory.
If the FetchBatchSize property is also set, it should be less than or equal to CacheLimit unless you know that the data you're passing over is of no use.
Caching uses up memory fairly quickly, so you should only cache large numbers of rows when it's really necessary; for example, when you want to move back and forth between rows.