查询缓存在Yii框架中不起作用

Question

I've a table containing more than 27,000 records. I want to fetch all data in Dropdown list. For that I've implemented cache but it seems to be not working as its getting very slow and showing blank page (Sometime browser is getting hanged).

Following is my code (I am using yiiboilerplate):

Configuration of backend/config/main.php in component array:

   'cache' => array(
        //'class' => 'system.caching.CMemCache',
        'class' => 'system.caching.CDbCache',
        'connectionID' => 'db',
    ),

In View page:

    $dependency = new CDbCacheDependency('SELECT MAX(bank_id) FROM bank');
    $bank = CHtml::listData(Bank::model()->cache(1000, $dependency)->findAll('is_active=1', array('order' => 'name')), 'bank_id', 'concatened');
    echo $form->dropDownListRow($model, 'bank_id', $bank, array(
        'empty' => 'Select'
    ));

I think 27000 records is not big data but still its getting very slow and I want to implement cache in my entire application.

Is my configuration correct? Where I am going wrong?

Thanks

Answer 1

I think your parameters in findAll is incorrect.

It should be:

Bank::model()
    ->cache(1000, $dependency)
    ->findAll([
       'select' => 'bank_id',
       'order' => 'name ASC', // if it is in ascending order
       'condition' => 'is_active = 1'
    ]);

I don't know what concatened so I just ignored it. But you can always use scopes for your conditions.