Auto Cache

The AutoCache property controls automatic caching of data.

Data Type

bool

Default Value

false

Remarks

When AutoCache is set, the driver automatically caches the results of SELECT queries to a cache specified by the CacheLocation option. The CacheLocation is a simple, file-based cache. See the CacheConnection and CacheProvider properties to cache to other databases.

Non-queries (such as UPDATE/INSERT/DELETE statements) on the original tables will not modify the data in the cache at all, regardless of the value set for AutoCache.

Note that while Offline is TRUE, the driver ignores AutoCache.