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
The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|
