ADO CacheSize Property
 Complete Recordset Object Reference
The CacheSize property sets or returns a long value that specifies the number of records that
can be cached locally in memory.
The value must be greater than 0.
Note: You can change this property any time, as long as the Recordset exists, but
remember that the cached content will not change until the next retrieval from the database.
The default value for this property is 1. This means that only one record is fetched and cached at a time. For
large databases, this is not efficient. A larger value will speed up operations,
but remember that cached records may not show recent changes made to the
database. To avoid this you can call the Resync method regularly, which will update the
cache.
Syntax
Complete Recordset Object Reference
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
| 
