pontoon icon indicating copy to clipboard operation
pontoon copied to clipboard

Published 20 hours ago • verified publisher icon mozilla

Using the filter ‘Missing’ on Pontoon takes a long time.

Open Fjoerfoks opened this issue 1 year ago • 2 comments

I use https://pontoon.mozilla.org/fy-NL/all-projects/all-resources/?status=missing and https://pontoon.mozilla.org/nl/all-projects/all-resources/?status=missing to get to the latest missing strings in Pontoon. Since the last update loading of these results seems to have slowed down significantly.

Fjoerfoks avatar Sep 21 '23 13:09 Fjoerfoks

The following view was also reported to be slower: https://pontoon.mozilla.org/he/firefox/all-resources/?extra=missing-without-unreviewed&string=275204

mathjazz avatar Sep 21 '23 13:09 mathjazz

It seems like the response time of the pontoon.base.entities view (which powers the entity list) increased after we upgraded the DB from version 11 to 15 on September 13.

Screenshot 2023-09-28 at 16 22 55

Vertical lines represent deployments.

We should investigate DB requests and use standard DB optimization techniques, esp. indexes.

mathjazz avatar Sep 28 '23 14:09 mathjazz