Caching DbDependency makes multiple SQL queries

[cherifGsoul]

I have this code:

$dataProvider = new ActiveDataProvider([
            'query'=>Todolist::find()
            ]);
        $dependency = \Yii::createObject([
            'class'=>'\yii\caching\DbDependency',
            'sql' => 'SELECT MAX(updated_at) FROM todolist'
            ]);

        Todolist::getDb()->cache(function ($db) use ($dataProvider){
            $dataProvider->prepare();
        },3600,$dependency);

I was surprised by the number of the sql query executed with the sql param, it generates 4 queries

I wonder if this is a bug or is the default behavior of the framework? The yii\caching\FileCache was used.

Q	A
Yii version	2.0.7
PHP version	5.6.11-1ubuntu3.1
Operating system	Ubuntu 15.10 & 14.04

[cebe]

from a quick look it seems you just need to set the dependency to be reuseable: http://www.yiiframework.com/doc-2.0/yii-caching-dependency.html#$reusable-detail

[cherifGsoul]

@cebe thank you for the answer it works like a charm :+1:

[cebe]

still weird that it generates 4 queries, should be checked.

[cherifGsoul]

I dont find any test for DbDependency component, can someone point me to the right test?

[cebe]

I'm afraid there is none, it should be in https://github.com/yiisoft/yii2/tree/master/tests/framework/caching