Query caching yii framework

Yii 1.1 General Discussion
1

I want to find the total score of the loggedin user & want to cache it.

My code is:


$dependency = new CDbCacheDependency('SELECT MAX(id) FROM tbl_points_log where user_id='.Yii::app()->user->id);    

    $sql='SELECT SUM( point) as user_point FROM tbl_points_log left join tbl_action on tbl_action.id = tbl_points_log.action_type_id where user_id='.Yii::app()->user->id;

    $user_point = Yii::app()->db->cache(1000, $dependency)->createCommand($sql)->queryAll();

Do I have to make some changes in the config file to make query caching working? I just added the following under components




    'cache' => array(

                'class' => 'CDbCache'

            ),



var_dump($dependency->getHasChanged());

always evaluates to true, even if i did no changes into database, so why is that?

P.S Dont bother about the SQL statement. Its working!

2

I think in your config you need to put:




'cache'=> array(

        		'class'=>'system.caching.CDbCache',

  ),

Then the first time it’s normal that the query is executed, but the second time it shouldn’t.

3

Well thanks for the reply, but this is not at all the solution