Timeouts on personal page because of stuff-to-translate

Bug #423191 reported by Jeroen T. Vermeulen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Jeroen T. Vermeulen

Bug Description

My personal Translations page is timing out for me on edge now that stuff-to-translate has landed.

Example: OOPS-1341ED287

It may be affecting me more than others because some uploads I've done make the listing search for POFiles in more languages (15 in my case). The fix may be to make the listing ignore POFileTranslator entries for published uploads.

Related branches

Revision history for this message
Данило Шеган (danilo) wrote :

There's a lot of repeated queries (2400 queries): the main query doesn't seem to take that long.

Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

More examples: OOPS-1341EB283, OOPS-1341EC281, OOPS-1341EC282, OOPS-1341EC288, OOPS-1341EA250, OOPS-1341EA251, OOPS-1341EB216, OOPS-1341EA448, OOPS-1341ED420.

Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

The main randomized query can take quite long, though for some reason not always. But the big mistake was that I forgot to slice it before processing its results! That means on the one hand the query itself takes much longer than it needs to, but on the other a _lot_ more data gets fetched while aggregating.

I'm pushing a branch that fixes it. If that's still slow, well, we don't _really_ need to order this query by random() either. There may be something easier and faster.

Changed in rosetta:
assignee: nobody → Jeroen T. Vermeulen (jtv)
importance: Undecided → High
milestone: none → 3.0
status: New → In Progress
Revision history for this message
Jeroen T. Vermeulen (jtv) wrote :

Fixed in devel 9350

Changed in rosetta:
status: In Progress → Fix Committed
Changed in rosetta:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.