LOTUS CONNECTORS


FetchBatchSize property
Example

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