Comment 2 for bug 246200
Revision history for this message
| James Henstridge (jamesh) wrote Re: Archive index pages timeout because of inefficient storm.sqlobject __nonzero__ | #2 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
513534c
demo site
(Get the code!)
While that query is taking quite a while, it isn't clear that removing the ORDER BY would stop that page from timing out. There is a 19 second gap between statement #32 and the one where the TimeoutError was raised.
That should be investigated as well as fixing Storm to remove the ORDER BY clause.