Merge lp:~wgrant/launchpad/flatten-bfj-6-denorm-more-queries into lp:launchpad

Proposed by William Grant
Status: Merged
Merged at revision: 16481
Proposed branch: lp:~wgrant/launchpad/flatten-bfj-6-denorm-more-queries
Merge into: lp:launchpad
Prerequisite: lp:~wgrant/launchpad/flatten-bfj-5-app-cleanup
Diff against target: 0 lines
To merge this branch: bzr merge lp:~wgrant/launchpad/flatten-bfj-6-denorm-more-queries
Reviewer Review Type Date Requested Status
Steve Kowalik (community) code Approve
Review via email: mp+146817@code.launchpad.net

Commit message

Migrate BinaryPackageBuild queries to use the new distro/distroseries/distroarchseries/sourcepackagename/is_distro_archive columns for performance.

Description of the change

Migrate BinaryPackageBuild queries to use the new distribution, distro_series, distro_arch_series, source_package_name and is_distro_archive columns where appropriate. Makes BPB:+retry, D:+builds, DS:+builds, DAS:+builds almost correctly fast.

DistroArchSeriesSet was accidentally killed during the renovations.

To post a comment you must log in.
Revision history for this message
Steve Kowalik (stevenk) :
review: Approve (code)

Preview Diff

Empty