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

/*
 * Set the value of the cache directory before establishing a connection
 */
$ADODB_CACHE_DIR = 'd:/queries';