查询缓存 yii 框架

2022-01-04 00:00:00 caching php yii

我想找到登录用户的总分&想缓存它.我的代码是:

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();

上面的代码正确吗?我是否必须在配置文件中进行一些更改才能使查询缓存工作?我刚刚添加

Is the above code correct? Do I have to make some changes in the config file to make query caching working? I just added

'cache' => array(
     'class' => 'CDbCache'
 ),

在组件下

var_dump($dependency->getHasChanged()); 总是评估为真，即使我没有对数据库进行任何更改，那是为什么?

var_dump($dependency->getHasChanged()); always evaluates to true, even if i did no changes into database, so why is that?

P.S 不要理会 SQL 语句.它的工作！

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

推荐答案

最好的办法就是打开日志查看结果

the best way to find out that query results come from cache or database is that to turn on logging as follow and see the results

        'log'=>array(
            'class'=>'CLogRouter',
            'routes'=>array(
                array(
                    'class'=>'CFileLogRoute',
                    'levels'=>'error, warning',
                ), 
                array(
                    'class'=>'CWebLogRoute',
                ), 

            ),
        ),

相关文章