Documentation Home
MySQL Connector/Net Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 2.6Mb
PDF (A4) - 2.6Mb
EPUB - 1.6Mb
HTML Download (TGZ) - 1.6Mb
HTML Download (Zip) - 1.6Mb


MySQL Connector/Net Developer Guide  /  Connector/Net Programming  /  Using Connector/Net with Table Caching

5.8 Using Connector/Net with Table Caching

This feature exists with Connector/Net versions 6.4 and above.

Table caching is a feature that can be used to cache slow-changing datasets on the client side. This is useful for applications that are designed to use readers, but still want to minimize trips to the server for slow-changing tables.

This feature is transparent to the application, and is disabled by default.

Configuration

  • To enable table caching, add 'table cache = true' to the connection string.

  • Optionally, specify the 'Default Table Cache Age' connection string option, which represents the number of seconds a table is cached before the cached data is discarded. The default value is 60.

  • You can turn caching on and off and set caching options at runtime, on a per-command basis.


User Comments
Sign Up Login You must be logged in to post a comment.