search

johnitvn / yii2-rbac-plus

Database role base access control manager for yii2
49 stars 52 forks source link

Too many db queries #25

Open ekawalec opened 8 years ago

ekawalec commented 8 years ago

I suggest to minimize db queries. For example: 9 Users, 10 Permissions, 3 Roles gives approx. 60 'select' queries to tables named 'auth_%'. IMHO to many. Can you implement any caching method for your module?

ekawalec commented 8 years ago

solved (main.php):

    'cache' => [
        'class' => 'yii\caching\FileCache',
    ],
    'authManager' => [
        'class' => 'yii\rbac\DbManager',
        'cache' => 'yii\caching\FileCache',
    ],