Request is taking to long about passbolt_api HOT 3 CLOSED

Hey @grassdionera, with the v4.2.0 we've released few performance improvements related to SQL queries. You should try to upgrade and check if it reduces the loading time.

Also, we are in constant endeavour to improve performance with coming releases. Closing this issue for now but feel free to post in community forum if you face any problems or have questions.

from passbolt_api.

@grassdionera thank you for pointing this out. We are currently working on a command to purge the action_logs table, which will expectedly significantly reduce the time of the query you pointed.

How many entries do you have in your action_logs table, in order to have an rough idea?

Also note that opening issues on the passbolt forum is more convenient for the mainteners and the community. We can then keep you posted more easily when improvements related to your issue are published.

from passbolt_api.

Hey @pabloelcolombiano
thanks for the fast reply.
We have currently
729761 entries in the action logs table.

a purge command for the action logs would be good to have, for cleaning up some of the old logs.

but i think the problem of the above sqls will remain and they become slower from time to time.
We are a small company with not mutch entries. But someone with a lot more entries will also produce more action_logs. and so the sqls will become slower even if someone purges old logs

from passbolt_api.