launchpad-reviewers team mailing list archive

[Colin Watson <cjwatson@xxxxxxxxxxxxx>]

The proposal to merge lp:~cjwatson/launchpad/package-cache-indexes into lp:launchpad has been updated.

Description changed to:

Add a DistributionSourcePackageCache(sourcepackagename, archive) index.  This makes the upcoming changes to SourcePackageNameVocabulary to use the package cache perform much better - a few milliseconds vs. about a second on dogfood for reasonably typical queries.

Also add a DistributionSourcePackageCache(binpkgnames) index, which makes it feasible to implement a cache-aware equivalent of BinaryAndSourcePackageNameVocabulary using that column as well as SourcePackageName.name.  This is much faster than going through DistroSeriesPackageCache in that case.

This can be applied as a hot patch.

For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/package-cache-indexes/+merge/296379
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~cjwatson/launchpad/package-cache-indexes into lp:launchpad.