Caching Data

Because some data sources are slow to query against, the adapter supports a simple caching model that can improve the performance of data queries. The caching support is only provided for tables or views and is not available for stored procedures. See Data Model for more information.

Caching works by storing a copy of data in a database of your choice. This database is a persistent store which can be shared by multiple connection objects over time. You can select a database and configure it using the configuration options of the cache provider.

By default, a file system-based database is used. This database will be stored at the path in Location or at the path explicitly defined by the path in CacheLocation, both configured using the Connection String. If neither of these connection properties are specified, the adapter will use a platform-dependent default location.

The cache database can contain each table exposed by the Data Model of the adapter. See the section Caching Automatically for examples of caching automatically, or the read the section CACHE Statements to have more control over the cached data.