Sets or returns the number of records retrieved from an ODBC data source that will be cached locally. The setting or return value must be between 5 and 1200, but not greater than available memory will allow. A setting of 0 turns off caching.
Syntax
VOIDSetCacheSize(LONG l);
LONGGetCacheSize(VOID);
Set Parameters
| Type | Example | Description |
| LONG | l | A Long specifying the number of records that will be cached. |
Remarks
Data caching improves performance if you use Recordset objects to retrieve data from a remote server. When users request data, the Microsoft Jet database engine checks the cache for the requested data first rather than retrieving it from the server. The cache only saves data that comes from an ODBC data source.