Comment 1 for bug 471974
Revision history for this message
| Graham Binns (gmb) wrote Re: bug timing out without much sql time | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
bbfa235
(Get the code!)
I've seen this a couple of times with bug 131679, too (OOPS-1404EA298). In this case, it's more obvious to me that it's an dupe subscription problem. There's a jump between statement 137 (fetching the BugSubscriptions from dupes) and statement 138 (footling around with ValidPersonCache) of nearly 12 seconds.
Bug 131679 has 292 dupes which bring a grand total of 1061 extra subscriptions with them. The trouble is that the results set from the dupe subscription query get iterated over more than once in the code before they get displayed (see Bug.getSubscrip
I'm not entirely clear why all the subscribers' details are getting loaded with each page load, since we don't appear to display them any more unless you're viewing the page with a JS-enabled browser, in which case the subscribers list is loaded asynchronously anyway.
The simple way to solve this problem, then, is to find the piece of code that's getting the subscribers list unnecessarily and excise it.