ADOdb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== $ADODB_CACHE_DIR =====
<WRAP right>

|Type|String|
|Default|empty|
</WRAP>
===== Description =====

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 [[.connection:cacheexecute]]. 

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

in ''php.ini'' for security reasons.
===== Performance considerations =====
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
===== Syntax =====
<code php>
$ADODB_CACHE_DIR='/home/adodb/caching';
$SQL = "SELECT * FROM large_table";
$db->cacheExecute($SQL);
</code>


===== Recommended PHP Configuration =====
<code>
register_globals=off
</code>

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

<code bash>
chown -R apache /path/to/adodb/cache
chgrp -R apache /path/to/adodb/cache
</code>

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