# Performance issue on large password database v2.2.0

**URL:** <https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950>\
**Category:** Community Feedback\
**Created:** [August 16, 2018, 8:37am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950 "2018-08-16T08:37:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![eddie4](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/eddie4/32/96_2.png) [@eddie4](https://community.passbolt.com/u/eddie4)\
**Post date:** [August 16, 2018, 8:37am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/1 "2018-08-16T08:37:02Z")

</div>

This is a continuation of [Fix performance issue on large password database (2k / 4k passwords)](https://community.passbolt.com/t/fix-performance-issue-on-large-password-database-2k-4k-passwords/493)

Passbolt version: 2.2.1  
Client hardware: i5 7360U 16GB mem 1GBit connection to server  
Client software: 68.0.3440.106 & Firefox 61.0.2 (64-bits)  
Server hardware: 2 xeon processing cores 4GB mem (620MB in use)  
Server response info:  
2187 passwords  
1.751 milliseconds  
4,4MB response (4.428.100 bytes) from  
GET /resources.json?contain%5Bcreator%5D=1&contain%5Bfavorite%5D=1&contain%5Bmodifier%5D=1&contain%5Bsecret%5D=1&contain%5Bpermission%5D=1&contain%5Btag%5D=1&order%5B%5D=Resource.modified+DESC&silentLoading=false&api-version=v2

 ![1_censored](https://canada1.discourse-cdn.com/flex031/uploads/passbolt/original/1X/b3e1ca59dc229da0d6cfe9e3c9368547b694c14c.png)

When looking at the waterfall we can see it starting to request the main json file at 1,86s and finish 3,44.(which is 4 times as long as it used to take in 1.6.1) It then spends a long time parsing, showing the results after 15,09 seconds.

---

<div class="post-metadata">

**Author:** ![cedric](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/cedric/32/3868_2.png) [@cedric](https://community.passbolt.com/u/cedric)\
**Post date:** [August 16, 2018, 8:58am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/2 "2018-08-16T08:58:19Z")

</div>

Hello @eddie4,

Thank you for the detailed report.

The first step of the fix was to make the js client able to treat a large amount of data without freezing the browser. What I guess you are not encountering anymore.

The very next step is to reduce the size of the requests by removing unnecessary data from the API responses, and so light up the treatment browser side.

This development is already scheduled (for the CE) along with another pro feature “audit log” and should be released in September.

Cheers

---

<div class="post-metadata">

**Author:** ![eddie4](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/eddie4/32/96_2.png) [@eddie4](https://community.passbolt.com/u/eddie4)\
**Post date:** [October 9, 2018, 8:17am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/3 "2018-10-09T08:17:18Z")

</div>

So how is this coming along your speaking of a September release we are now in October.

---

<div class="post-metadata">

**Author:** ![remy](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/remy/32/17_2.png) [@remy](https://community.passbolt.com/u/remy)\
**Post date:** [October 9, 2018, 8:25am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/4 "2018-10-09T08:25:31Z")

</div>

@eddie4 this was indeed delayed. Next release coming up in a few days will have MFA and bulk actions. We have a lot of features to ship and a lot of non-engineering tasks to complete, so bear with us with the timeline estimates.

---

<div class="post-metadata">

**Author:** ![eddie4](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/eddie4/32/96_2.png) [@eddie4](https://community.passbolt.com/u/eddie4)\
**Post date:** [October 22, 2018, 8:14am UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/5 "2018-10-22T08:14:41Z")

</div>

I just upgraded to 2.4.1 loadtime is currently 13.11 seconds.

---

<div class="post-metadata">

**Author:** ![cedric](https://yyz1.discourse-cdn.com/flex031/user_avatar/community.passbolt.com/cedric/32/3868_2.png) [@cedric](https://community.passbolt.com/u/cedric)\
**Post date:** [February 12, 2019, 4:21pm UTC](https://community.passbolt.com/t/performance-issue-on-large-password-database-v2-2-0/950/6 "2019-02-12T16:21:21Z")

</div>

Hello @eddie4,

We just release the v2.7.0 which addresses performance issues on large database.  
See the [release notes](https://help.passbolt.com/releases/ce/v270-jump) for more information.

Cheers
