w3schools
Search W3Schools :  
  
HOME HTML CSS XML JAVASCRIPT ASP PHP SQL MORE...   References Examples Forum About

ADO CacheSize Property


Recordset Object Reference 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

objRecordset.CacheSize


Recordset Object Reference Complete Recordset Object Reference

1,050,724 Sites built with Wix. Make your own!

Click here to design a Stunning Flash Website for Free

Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.

With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.


WEB HOSTING
Best Web Hosting
PHP MySQL Hosting
Top 10 Web Hosting
UK Reseller Hosting
Web Hosting
FREE Web Hosting
Top Web Hosting
Windows Hosting
WEB BUILDING
Download XML editor
FREE Flash Website
FREE Web Templates
Website Monetization
FLIGHT TICKETS
Find the cheapest flight
to any destination now!
EDUCATION
US Web Design Schools
HTML Certification
JavaScript Certification
XML Certification
PHP Certification
ASP Certification
STATISTICS
Browser Statistics
Browser OS
Browser Display

W3Schools.com HOME | TOP | PRINT | FORUM | ABOUT
W3Schools is for training only. We do not warrant the correctness of its content. The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our terms of use and privacy policy.
Copyright 1999-2009 by Refsnes Data. All Rights Reserved.