Slow on copying passwords from folder with ~ 3000 records

Installation Issues
#1

Hello,
It happens a slowdown when copying a password from folder which contains around 3000 records. We enter the folder and copy the password by clicking on it:

passbolt_copy
passbolt_copy271×611 2.21 KB

slowdown
slowdown1152×648 14.5 KB

It can happen that it will stay around 20seconds on that stage: Decrypting secret 50%
Is this a normal behavior with such count of records or we can improve something ?
Thank you!

#2

Hi Pavel,

Can you tell us more about your installation:

  • Which version are you running?
  • Which installation method did you use?
  • Do you see any error in the browser console around that time?
  • Can you check in the browser console what is taking the time, is it the description itself or the request for the secret (you can see if the request is slow in the browser extension network tab).

Some help to get the info:

Do you seen any error in the browser console?
If you right click on the page, click “inspect” or “inspect element” then click on the console tab.
Tell us more about which browser you are using and which version.

Do you seen any error in the browser extension console?
This is different from the previous console.

  • If you are using Google Chrome can you please go to: chrome://extensions ; Activate the Developer mode in the top right corner ; look for the Passbolt card and click details button ; Looks for the Inspect views and the index.html link ; A new window will appear this is the debugger of the browser extension, try to reproduce the error and send us the logs
  • On Firefox, you can go to: about:debugging#/runtime/this-firefox ; Then locate Passbolt and click Inspect ; A new tab for the console of the browser extension will appear.
#3

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

2021-04-12_18h32_10
2021-04-12_18h32_10861×1039 111 KB

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.

#4

We’ll investigate and come back to you on this.