Yii2: Cache RBAC assignments

[RomeroMsk]

Save SELECT * FROM auth_assignment WHERE user_id='...' results in User component property to avoid duplicate DB queries on one page.
See comment here.

[RomeroMsk]

Any thoughts?

[williamyiu]

I ran into the same issue as well.

[juban]

:+1:
I also think this is a major performance issue in some scenarios.
I'm maybe off topic here (sorry), but here is a very simple workaround :

class DbManagerEx extends DbManager
{
    private $_assignments = [];

    public function getAssignments($userId)
    {
        // Avoid multiple queries per request
        if(!isset($this->_assignments[$userId]))
            $this->_assignments[$userId] = parent::getAssignments($userId);
        return $this->_assignments[$userId];
    }

}

[acuom]

@samdark did this ever get done?

as I am getting hundreds of

SELECTb.* FROMauth_assignmenta,auth_itembWHERE ((a.item_name=b.name) AND (a.user_id='91')) AND (b.type=1)

On some pages 👎

[samdark]

Not yet. Scheduled for next release though.

[acuom]

@samdark ahh ok, any tips how the above problem could be solved in the meantime?

[samdark]

Try using file storage instead.