[PHP] pobierz, plaintext 
<?php
$servers = array(
        'host' => 'localhost',
        'port' => 11211,
        'persistent' => true
    );
 
    $cacheDriver = new Doctrine_Cache_Memcache(array(
            'servers' => $servers,
            'compression' => false
        )
    );
 
   $conn->setAttribute(Doctrine::ATTR_QUERY_CACHE, $cacheDriver);    
    $conn->setAttribute(Doctrine::ATTR_RESULT_CACHE, $cacheDriver);
    
 
$q = Doctrine_Query::create();
    $q->from('Aktualnosci')->useResultCache(true);
    $rows = $q->execute();    
print_r($rows->toArray());
?>
[PHP] pobierz, plaintext 

Cytat(Sajrox @ 31.07.2009, 11:11:40 )

Ewentualnie gdyby ktoś miłą inny system cache do zaproponowania to czekam na sugestie np. jak korzystać z SqLite cache.  Może jakiś przykład kodu ? Na pewno się przyda 

[PHP] pobierz, plaintext 
<?php
$conn  = Doctrine_Manager::connection(new PDO('sqlite::result_cache.sq'), 'sqlite_cache_connection');
$cacheDriver = new Doctrine_Cache_Db(array('connection' => $conn, 'tableName' => 'cache'));
// za pierwszym razem odkomenuj te linie, trzeba stworzyc tabele
//$cacheDriver->createTable();
 
$db = Doctrine_Manager::connection("mysql://user:pass@host/db", 'mysql');
Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_RESULT_CACHE, $cacheDriver);
Doctrine_Manager::getInstance()->setAttribute(Doctrine::ATTR_RESULT_CACHE_LIFESPAN, 3600);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$temp = Doctrine_Query::create()->from('Color c')->leftJoin('c.Translation t1 INDEXBY t1.lang')->where('c.id=?', $id)->setHydrationMode(Doctrine::HYDRATE_ARRAY)->useResultCache(true)->execute();
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$profiler = new Doctrine_Connection_Profiler();
$db->setListener($profiler);
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
useResultCache(true)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$oManager->setAttribute(Doctrine::ATTR_RESULT_CACHE, $oCacheDriver);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
public function useResultCache($driver = true, $timeToLive = null)
    {
        if ($driver !== null && $driver !== true && ! ($driver instanceOf Doctrine_Cache_Interface)) {
            $msg = 'First argument should be instance of Doctrine_Cache_Interface or null.';
            throw new Doctrine_Query_Exception($msg);
        }
        $this->_resultCache = $driver;
 
        if ($timeToLive !== null) {
            $this->setResultCacheLifeSpan($timeToLive);
        }
        return $this;
    }
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$manager->setAttribute(Doctrine::ATTR_RESULT_CACHE_LIFESPAN, 0);
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
useResultCache(true)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
 $manager->setAttribute(Doctrine::ATTR_RESULT_CACHE_LIFESPAN, 10);
 
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
                $q = new Doctrine_Query();
                $q    ->from('Tabela')
                         ->where('id=?', 1);
 
                $rows = $q->fetchArray();
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
            $q    ->setHydrationMode(Doctrine::HYDRATE_ARRAY)
                     ->useResultCache(true);
 
            $array = $q->execute();
[PHP] pobierz, plaintext 

1. useResultCache(true);

Cytat(mrok @ 11.08.2009, 18:38:55 )

[PHP] pobierz, plaintext 
useResultCache(true)
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
//$cache_allowed = true;
$cache_allowed = null;
$query->useResultCache($cache_allowed);
[PHP] pobierz, plaintext