+needattentiontickets page timing out
Bug #76319 reported by
Diogo Matsubara
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Launchpad itself |
Fix Released
|
Critical
|
Francis J. Lacoste | ||
Bug Description
A page like https:/
OOPS-351B23
OOPS-351D29
OOPS-351D24
Revision history for this message
| Stuart Bishop (stub) wrote | #1 |
| Changed in launchpad-support-tracker: | |
| status: | Unconfirmed → Confirmed |
Revision history for this message
| Francis J. Lacoste (flacoste) wrote | #2 |
| Changed in launchpad-support-tracker: | |
| assignee: | nobody → flacoste |
| importance: | Undecided → Critical |
Revision history for this message
| Francis J. Lacoste (flacoste) wrote | #3 |
| Changed in launchpad-support-tracker: | |
| status: | Confirmed → In Progress |
Revision history for this message
| Francis J. Lacoste (flacoste) wrote | #4 |
| Changed in launchpad-support-tracker: | |
| status: | In Progress → Fix Committed |
Revision history for this message
| Francis J. Lacoste (flacoste) wrote | #5 |
| Changed in launchpad-support-tracker: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
At least one of the subselects references its containing context, which means it needs to be executed once for every row in the containing context. The slow query needs to be rewritten. I'd give it a go, but I don't know what the question being asked actually is and would rather not reverse engineer the SQL.