To maximize the performance of disk-based caching systems, the cached data should be placed on the fastest available file system, in order of preference:

• A memory based file system (ramdisk), examples:
  • A windows product such as RamDisk
• A linux tmpfs type file system
• An SSD Disk based file system
• A alternative disk to the one holding the database

Placing the cache files on a network drive is not recommended.

The directory where the queries are saved is controlled by the variable $ADODB_CACHE_DIR

The parameter $cacheSecs sets the default value of the time in seconds that cached queries are saved. If not set then the value is 3600. It can be set via either a normal connection object or a DSN type connection configuration.

This default value can be overridden on a query by query basis

/*
 * A connection object assumed
 */
$ADODB_CACHE_DIR = 'd:/queries';
$db->cacheSecs   = 6000;