LOTUS CONNECTORS
Read-write. Specifies the number of records that will be fetched at any one time. The default is 1 (get just the requested record).
Defined in
ODBCResultSet
Data type
Long
Syntax
To get: size& = odbcResultSet.FetchBatchSize
To set: odbcResultSet.FetchBatchSize = size&
Usage
Use FetchBatchSize to fine-tune performance. Fetching multiple records is faster than fetching single records. If the CacheLimit property is also set, it must be greater than or equal to FetchBatchSize, unless you know that the data you're passing over is of no use.
Fetching multiple records at once requires caching, which uses up memory fairly quickly. 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