# Slow on copying passwords from folder with ~ 3000 records
**URL:** https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755
**Category:** Installation Issues
**Created:** [April 6, 2021, 1:09pm UTC](https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755 "2021-04-06T13:09:45Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@pavel](https://community.passbolt.com/u/pavel)
#### Post date: [April 6, 2021, 1:09pm UTC](https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755/1 "2021-04-06T13:09:45Z")
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:
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!
---
### Author:  [@remy](https://community.passbolt.com/u/remy)
#### Post date: [April 6, 2021, 2:14pm UTC](https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755/2 "2021-04-06T14:14:22Z")
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.
---
### Author:  [@Emilien](https://community.passbolt.com/u/Emilien)
#### Post date: [April 12, 2021, 4:46pm UTC](https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755/3 "2021-04-12T16:46:47Z")
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.
---
### Author:  [@remy](https://community.passbolt.com/u/remy)
#### Post date: [April 13, 2021, 5:14am UTC](https://community.passbolt.com/t/slow-on-copying-passwords-from-folder-with-3000-records/3755/4 "2021-04-13T05:14:32Z")
We’ll investigate and come back to you on this.