I am developing an application which is Role based system. So I am trying to know what is the Laravel way to deal with following problem:
I've been using this method of checking for role Auth::user()->hasRole('admin'), throughout my layout and view files.
It was only until I installed Laravel Debugbar that I realise there were multiple repeated database queries. For instance, 19 statements were executed, 18 of which were duplicated, 1 unique
Most of them were:
select exists(select * from `roles` inner join `role_user` on `roles`.`id` = `role_user`.`role_id` where `role_user`.`user_id` = '1' and `id` = '1') as `exists`
So here I want to know how to solve this repeated query problem, what is the laravel way.
You could try to eagerload all roles associated with the user so that future requests aren't necessary...
That said, there is a lot that goes into building a decent RBAC system and if you're not careful, it can end up doing a lot of queries... Currently, it seems to me as if the two most popular packages for handling roles and permissions are JosephSilber/bouncer and spatie/laravel-permission; both of which implement a cache system to reduce the number of times the DB gets hit.
If you're wanting to roll your own, I'd still suggest comparing those two to get an idea for how they address the issue you're running into.
