Hi,
CDbCacheDependency use:
$csql = 'select * from table';
$dependency = new CDbCacheDependency('SELECT MAX(time) FROM table');
$counts = Yii::app()->db->cache(5000, $dependency)->createCommand($csql)->queryScalar();
How to use the CSqlDataProvider function?