Order 'most recently closed' on 'Bugtask.id DESC' instead of 'BugTask.id'
Bug #121363 reported by
Björn Tillenius
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
High
|
Robert Collins |
Bug Description
The query for find the most recently closed bugs currently takes quite a long time to execute, since some index isn't being used. We need to change it to order by 'BugTask.id DESC' instead of 'BugTask.id'
Bug 43821 is related.
Related branches
lp:~lifeless/launchpad/bug-121363
- Stuart Bishop (community): Approve (db)
-
Diff: 24 lines (+15/-0)2 files modifieddatabase/schema/patch-2208-08-3.sql (+8/-0)
database/schema/patch-2208-15-0.sql (+7/-0)
Changed in malone: | |
importance: | Critical → High |
Changed in malone: | |
assignee: | nobody → schwuk |
Changed in malone: | |
status: | Confirmed → In Progress |
Changed in malone: | |
milestone: | 1.1.10 → 1.1.11 |
Changed in malone: | |
assignee: | schwuk → allenap |
Changed in malone: | |
assignee: | Gavin Panella (allenap) → nobody |
To post a comment you must log in.
Major oopser.