launchpad-reviewers team mailing list archive

[William Grant <me@xxxxxxxxxxxxxxxxxx>]

William Grant has proposed merging lp:~wgrant/launchpad/gPSPN-indices into lp:launchpad.

Commit message:
Add xPPH(archive, Xpackagename, status) indices for guessPublishedSourcePackageName

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)
Related bugs:
  Bug #1328355 in Launchpad itself: "Distribution.guessPublishedSourcePackageName times out frequently"
  https://bugs.launchpad.net/launchpad/+bug/1328355

For more details, see:
https://code.launchpad.net/~wgrant/launchpad/gPSPN-indices/+merge/222585

Add xPPH(archive, Xpackagename, status) indices for guessPublishedSourcePackageName. It would be somewhat useful to include id for the sort, but active records are few enough, and the primary/partner query has to sort in memory anyway.
-- 
https://code.launchpad.net/~wgrant/launchpad/gPSPN-indices/+merge/222585
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~wgrant/launchpad/gPSPN-indices into lp:launchpad.

=== added file 'database/schema/patch-2209-53-5.sql'
--- database/schema/patch-2209-53-5.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-53-5.sql	2014-06-10 03:32:10 +0000
@@ -0,0 +1,11 @@
+-- Copyright 2014 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+CREATE INDEX sourcepackagepublishinghistory__archive__spn__status__idx
+    ON sourcepackagepublishinghistory (archive, sourcepackagename, status);
+CREATE INDEX binarypackagepublishinghistory__archive__bpn__status__idx
+    ON binarypackagepublishinghistory (archive, binarypackagename, status);
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 53, 5);