/rosetta/imports/ page timing out
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Won't Fix
|
Medium
|
Unassigned |
Bug Description
Kiko's analysis of OOPS-117B155
"They are actually lots of TeamParticipation queries that are interspersed with:
57. 637 0ms SELECT mimetype, last_accessed, expires,
58. 637 1ms SELECT filename, deleted FROM LibraryFileAlias,
It appears that we could avoid at least the first query by using
prejoining on TranslationImpo
If we had double-dotted prejoining we could do "content.content" and
avoid the second query as well."
OOPS-290C291
Changed in rosetta: | |
assignee: | nobody → kiko |
status: | Unconfirmed → Confirmed |
description: | updated |
Have a simple patch for this, but blocked in Stuart giving me input on why LibraryFileAlias is so slow to join in.