Database Caching Class

[eluser]freakylp[/eluser]

Code:

load this to library using autoload
<?php



    class Memcached{
        
        
        
        public $memcache;
        
        
        
        
        
        public function __construct()
        {
            $this->memcache     =     new Memcache;
            $this->conn         =     $this->memcache->connect('localhost', 11211);
            $this->time            =    300; //cache time in seconds
            $this->method_stop    =    "add_comment";//dont cache query if you have in uri this
        }
        
        
        
        
        
        
        public function set( $key , $value  )
        {
            $this->memcache->set( md5( $key ).$_SERVER['SCRIPT_FILENAME'] , $value , 0 , $this->time );
        }
        
        
        
        
        public function get( $key )
        {
            return $this->memcache->get( md5( $key ).$_SERVER['SCRIPT_FILENAME'] );
        }
        
        
        
    }




?>

extend Model using this:

Code:

<?php




    class My_Model extends  Model{
        
        
        
        public function __construct()
        {
            parent::__construct();
            
        }
        
        
        
        
        
        
        
        
        public function dbquery( $query )
        {
            if( $this->memcached->get( $query ) == false )
            {
                $this->load->database();
                    
                
                $q            =    $this->db->query( $query );
                $this->memcached->set( $query , $q->result()  );
                
                return $q->result();
                
            }
            return $this->memcached->get( $query );
        }
        
        
        
        
    }




?>

dont autoload database library // it will be loaded if cache expire

And thats it.
You can create config file for memcache settings.
It doesnt work with active_record queries.
It works with only sql queries.