$ADODB_CACHE_DIR

If you are using recordset caching, this is the directory to save your recordsets in. There is no default definition . Define this before you call any caching functions such as cacheExecute.

If using this feature with PHP versions less than 5.4 we recommend setting

register_globals=off

in php.ini for security reasons.

The speed of the query retrieval is dependent on the systems ability to read text files from a file system. Consider placing the cached queries on an SSD if available, or an in-memory filesystem

$ADODB_CACHE_DIR='/home/adodb/caching';
$SQL = "SELECT * FROM large_table";
$db->cacheExecute($SQL);

register_globals=off

You might need to set your cache directory permissions to something similar to the following:

chown -R apache /path/to/adodb/cache
chgrp -R apache /path/to/adodb/cache

The directory that is used to save the cache files must be readable and writable by the IIS owner process.