Excessive memory usage

[tuimz]

Describe the bug
We have 188 permissions, 8 roles, 182 records in role_has_permissions and 32 records in model_has_permissions our database table.

Take the following test request in web.php

Route::get('/test', function () {
    return response('OK', 200);
})

Wich results in about 40mb memory usage. However if we change that to

Route::get('/test', function () {
    auth()->user()->can('view-dashboard');
    return response('OK', 200);
})

Memory used for the request to ~530mb

Versions

• spatie/laravel-permission package version: 5.5.2
• illuminate/framework package: 8.83.4

PHP version: 8.1.3

Database version: Mysql 8.0.28

Environment (please complete the following information, because it helps us investigate better):

• OS: Linux
• Version: Kernel 5.16.11

[tuimz]

I want to add if I set the config permission.cache.store to array the memory usage goes down to 40mb again

[erikn69]

I have 389 permissions and 13 roles and many records on role_has_permissions/ model_has_permissions, and only 6mb with laravel debugbar, without debugbar 3 or 4, you are doing something wrong, test on a fresh instalation

[salvorl]

@tuimz did you solve it?
I've a similar problems, and I don't know how manage it.
I have 6694 Role and 137 Permission.

[parallels999]

spatie version is 2.37

spatie current version is 5.7, Most likely this problem has already been fixed.

• Make cache more than 90% smaller and Speed up permissions cache lookups #1799
• [V5] Cache loader improvements #1912

[erikn69]

My debugbar loads model by spatie in erikn69 reply image the roles are in App/model).

@salvorl I have custom models extending spatie models

spatie version is 2.37

Spatie laravel permissions 2.37 has no support, only latest version(V5) has support

[salvorl]

The project was at laravel 5.8.
Now I'm trying to update to laravel 6, after that I'll update to laravel 7.

PS
I want to report that in the prerequisite of V5 documentation the laravel version supported is 6, in last composer is 7

[salvorl]

With the 5.7 version the improvement is impressive.
The memory go down from 110 MB to 9 MB

[erikn69]

I want to report that in the prerequisite of V5 documentation the laravel version supported is 6, in last composer is 7

In the first v5 releases, it supported laravel 6

With the 5.7 version the improvement is impressive.

Thanks, it was one of my first contributions #1799

Also this idea could help with memory and time #1833.