Hi,
We’re also experiencing slow password decryption. It seems that some requests are very very long to execute when moving between folders :
- red : requests sent when navigating through the folder tree
- green : the first password decryption when I’m in the right folder
- blue : next passwords decryptions when I stay in the same folder
We can see that resources.json, groups.json, folders.json requests are really slow. In mysql SHOW FULL PROCESSLIST we can see that the following request is taking much time to execute (more than 10 seconds):
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`, Resources.resource_type_id AS `Resources__resource_type_id`, 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 LEFT JOIN permissions Permission ON (Permission.id = (SELECT Permissions.id AS `Permissions__id` FROM permissions Permissions WHERE (aco = 'Resource' AND (Permissions.aro_foreign_key = '55ed22fc-c3a2-473a-848a-700712edfdd9' OR Permissions.aro_foreign_key in (SELECT GroupsUsers.group_id AS `GroupsUsers__group_id` FROM groups_users GroupsUsers WHERE GroupsUsers.user_id = '55ed22fc-c3a2-473a-848a-700712edfdd9')) AND Permissions.aco_foreign_key = Resources.id) ORDER BY Permissions.type DESC LIMIT 1) AND Resources.id = (Permission.aco_foreign_key)) LEFT JOIN favorites Favorites ON (Favorites.user_id = '55ed22fc-c3a2-473a-848a-700712edfdd9' AND Resources.id = (Favorites.foreign_key)) WHERE (Resources.deleted = 0 AND Resources.id in (SELECT DISTINCT Permissions.aco_foreign_key AS `Permissions__aco_foreign_key` FROM permissions Permissions WHERE (aco = 'Resource' AND (Permissions.aro_foreign_key = '55ed22fc-c3a2-473a-848a-700712edfdd9' OR Permissions.aro_foreign_key in (SELECT GroupsUsers.group_id AS `GroupsUsers__group_id` FROM groups_users GroupsUsers WHERE GroupsUsers.user_id = '55ed22fc-c3a2-473a-848a-700712edfdd9'))))) ORDER BY Resources.name ASC
Can you help us with this issue ?
Thanks,
Regards.