Robert Collins has proposed merging lp:~lifeless/launchpad/bug-618396 into lp:launchpad.
Requested reviews: Stuart Bishop (stub): db Launchpad code reviewers (launchpad-reviewers) Related bugs: #618396 MaloneApplication:+bugs timeouts in ~2% of requests https://bugs.launchpad.net/bugs/618396 Permit bug searches by importance to be ordered from index. -- https://code.launchpad.net/~lifeless/launchpad/bug-618396/+merge/35970 Your team Launchpad code reviewers is requested to review the proposed merge of lp:~lifeless/launchpad/bug-618396 into lp:launchpad.
=== added file 'database/schema/patch-2208-99-0.sql' --- database/schema/patch-2208-99-0.sql 1970-01-01 00:00:00 +0000 +++ database/schema/patch-2208-99-0.sql 2010-09-19 23:41:09 +0000 @@ -0,0 +1,8 @@ +SET client_min_messages=ERROR; + +-- Permit bug searches ordered by 'importance' - the default - to serve from +-- index rather than doing the full search and sorting. + +CREATE INDEX bugtask_importance_idx ON BugTask (importance, id desc nulls first); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
