Comment 1 for bug 723999
Revision history for this message
| Gary Poster (gary) wrote Re: structural subscriptions taking 4.8 seconds during nomination editing POST | #1 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
0e1f616
(Get the code!)
I'm fairly sure this comes from code in lp.bugs.
To satisfy my own curiosity, some small hand-made stats about the long queries.
- There are four verrrry similar long queries, each taking between 1 and 1.5 seconds. They may (hopefully) differ in the variables they use when they are called. I wouldn't be surprised if the four are looking at different duped bugs.
- Each unions query unions three distinct select statements, each of which is repeated several times. In the first long query, for instance, the first and second are *each* repeated (unioned) five times; the last is repeated four times. Other long queries apparently vary this somewhat (the second has five, five, and one), but the three unioned queries are identical across all four long queries.