I’ve opened another topic (this: Bad performance on page loading), but unfortunatly I could not respond in time, so I write you again for my issue (bad performance on Passbolt).
I have done some investigation, and I have some news about my performance problem.
I have isolated the query that take > 10 sec to be executed, this:
SELECT Resources.id AS
Resources__id, Resources.name AS
Resources__name, Resources.username AS
Resources__username, Resources.uri AS
Resources__uri, Resources.description AS
Resources__description, Resources.deleted AS
Resources__deleted, Resources.created AS
Resources__created, Resources.modified AS
Resources__modified, Resources.created_by AS
Resources__created_by, Resources.modified_by AS
Resources__modified_by, Permission.id AS
Permission__id, Permission.aco AS
Permission__aco, Permission.aco_foreign_key AS
Permission__aco_foreign_key, Permission.aro AS
Permission__aro, Permission.aro_foreign_key AS
Permission__aro_foreign_key, Permission.type AS
Permission__type, Permission.created AS
Permission__created, Permission.modified AS
Permission__modified, Favorites.id AS
Favorites__id, Favorites.user_id AS
Favorites__user_id, Favorites.foreign_key AS
Favorites__foreign_key, Favorites.foreign_model AS
Favorites__foreign_model, Favorites.created AS
Favorites__created, Favorites.modified AS
Favorites__modified FROM resources Resources INNER JOIN permissions Permission ON Resources.id = (Permission.aco_foreign_key) LEFT JOIN favorites Favorites ON (Favorites.user_id = ‘’ AND Resources.id = (Favorites.foreign_key)) WHERE (Resources.deleted = 0 AND Permission.id = (SELECT Permissions.id AS
Permissions__id FROM permissions Permissions WHERE (Permissions.aco_foreign_key = Resources.id AND (Permissions.aro_foreign_key = ‘’ OR Permissions.aro_foreign_key in (SELECT Groups.id AS
Groups__id FROM groups Groups INNER JOIN groups_users GroupsUsers ON Groups.id = (GroupsUsers.group_id) INNER JOIN users Users ON Users.id = (GroupsUsers.user_id) WHERE (Groups.deleted = 0 AND Users.id = ‘’))) AND Permissions.type in (1,7,15)) ORDER BY Permissions.type DESC LIMIT 1)) ORDER BY Resources.modified DESC;
I’m not a MySQL expert, and I don’t know why it could take this amount of time.
Could you please help me?