How to use Query cache with ADODB?

Question

How to use Query cache with ADOdb in PHP? Is it default in ADOdb or Is there any configuration needed ?

Answer 1

Set the cache directory, e.g.

$GLOBALS['ADODB_CACHE_DIR']=$_SERVER['DOCUMENT_ROOT'].'/../cache/adodb';

Now you can use the Cache* methods like CacheGetOne to get a cached result

$data = $rs->CacheGetOne($seconds_to_cache, $sql);