As of sf 1.4

http://www.symfony-project.org/advent_calendar/12/en

http://www.doctrine-project.org/documentation/manual2/1_0/en/one-page#caching

http://www.sfblog.fr/page/utiliser-memcache-avec-doctrine-sous-symfony

Setup for sf 1.2

In the ProjectConfiguration:

•   public function initialize()
    {
      //enable Doctrine cache
      $manager = Doctrine_Manager::getInstance();
      $cacheDriver = new Doctrine_Cache_Apc();
      $manager->setAttribute(Doctrine::ATTR_RESULT_CACHE, $cacheDriver);
    }

Example query (in UllFlowAppTable.class.php):

•   /**
     * Find by Id
     *
     * @param integer $id
     * @return Doctrine_Record
     */
    public static function findById($id)
    {
      $q = new Doctrine_Query;
      $q
        ->from('UllFlowApp')
        ->where('id = ?', $id)
        ->useResultCache(true)
      ;
  
      return $q->execute()->getFirst();
    }