Launchpad itself

  1. Bug #668138
  2. Comment #3

Comment 3 for bug 668138

Revision history for this message
Robert Collins (lifeless) wrote : Re: [Bug 668138] Re: Person:+commentedbugs timeouts

You're talking about this bit specifically right?
SELECT BugMessage.message FROM BugMessage
               WHERE BugMessage.bug = BugTask.bug

being a correlated subquery with the next outer query ?
That looks like an awkward way to say 'filed by this user' anyhow.
'owner' is that person and it will be heaps faster.