Returns or sets the number of records that are cached in local memory for the current DECommand object.
Syntax
object.CacheSize [=value]
The CacheSize property syntax has these parts:
| Part | Description |
| object | An object expression that evaluates to an item in the Applies To list. |
| value | Integer. A numeric expression that specifies the number of records that are cached in local memory for the current DECommand object. The default is 10 records. |
Remarks
The value tells the provider how many records to keep in its fat buffer and how many records to fetch at one time to local memory. For example, when set to 10, after opening the first Recordset the provider fetches the first 10 records into local memory. Therefore, as you move forward from the current record, the provider returns the data values from the local memory buffer. As soon as you move past the last record, the next 10 records are fetched from the data source (or cursor library) into the cache.
While you can change value during the life of the cursor, the change only affects the number of records in the cache after the next fetch from the data source (or local cursor library).
This property corresponds to the ADO Recordset CacheSize property.