$timer->setMark('redis2'); echo count($rs), PHP_EOL; /** * Cache for 5 minutes with key: mykey using disk cache */ $db->useCache($disk); $rs = $db->CacheGetAll(300, $sql, 'mykey'); $timer->setMark('disk'); echo count($rs), PHP_EOL; $rs = $db->CacheGetAll(300, $sql, 'mykey'); $timer->setMark('disk2'); echo count($rs), PHP_EOL; /** * flush the query $sql with key on DISK cache instance */ $db->CacheFlush($sql, 'mykey'); /** * flush the query $sql with key only on Redis cache instance */ $db->useCache($redis); $db->CacheFlush($sql, 'mykey'); /** * flush all the cache in all instances */ foreach (array('memcache', 'redis', 'disk') as $val) { $db->useCache(${$val}); $db->CacheFlush($sql, 'mykey'); } # ------------------------------------------------------------------------------ echo PHP_EOL, str_repeat('-', 80), PHP_EOL; $timer->printMarks();
/** * Cache for 1 hour (default), group C */ $rs = $db->CachePGetAll('SELECT * FROM Country WHERE Population <= ?', 100000, 'group:C'); echo count($rs), PHP_EOL; $timer->setMark('default'); /** * lazy connection test query DB only when needed */ $db->debug(); $db->closeConnection(); /** * Cache for 5 minutes, group A */ $rs = $db->CachePGetAll('SELECT * FROM Country WHERE Region = ?', 'Caribbean'); echo count($rs), PHP_EOL; $timer->setMark('lazy'); /** * flush only group A */ $db->CacheFlush('group:A'); /** * Cache for 5 minutes, group A */ $rs = $db->CachePGetAll(300, 'SELECT * FROM Country WHERE Region = ?', 'Caribbean', 'group:A'); echo count($rs), PHP_EOL; $timer->setMark('connect'); # ------------------------------------------------------------------------------ echo PHP_EOL, str_repeat('-', 80), PHP_EOL; $timer->printMarks(); echo str_repeat('-', 80), PHP_EOL, 'Time: ', $timer->getPageLoadTime(), ' - Memory: ', $timer->getMemoryUsage(1), PHP_EOL, str_repeat('-', 80), PHP_EOL;
public function testCacheFlushEnd() { $rs = $this->db->CacheFlush(); $this->assertTrue($rs); }