LOTUS CONNECTORS


CacheLimit property
Example

Read-write. The maximum number of rows to be cached in memory.

Defined in

ODBCResultSet

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.

Example
See Also