Table of Contents
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
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);
Recommended PHP Configuration
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.