/rosetta/imports/ page timing out

Bug #41954 reported by Diogo Matsubara
8
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,
                                filename, content FROM LibraryFileAlias
                                WHERE id = 1850504
        58. 637 1ms SELECT filename, deleted FROM LibraryFileAlias,
                                LibraryFileContent WHERE LibraryFileContent.id =
                                LibraryFileAlias.content AND LibraryFileAlias.id
                                = 1850504

    It appears that we could avoid at least the first query by using
    prejoining on TranslationImportQueueEntry, for the 'content' field.
    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
Revision history for this message
Christian Reis (kiko) wrote :

Have a simple patch for this, but blocked in Stuart giving me input on why LibraryFileAlias is so slow to join in.

Changed in rosetta:
status: Confirmed → In Progress
Revision history for this message
Carlos Perelló Marín (carlos) wrote :

kiko, are you still blocked?

Changed in rosetta:
status: In Progress → Needs Info
Revision history for this message
Christian Reis (kiko) wrote :

I never managed to find out a way of prejoining that without making the query slower. I added a comment to the code in question, but I'm closing this out as I don't think this page times out any longer. Please reopen if this is still an issue.

Changed in rosetta:
assignee: kiko → nobody
status: Incomplete → Won't Fix
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.