查询缓存 yii 框架 [英] Query caching yii framework

问题描述

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

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',
                ), 

            ),
        ),

这篇关于查询缓存 yii 框架的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！