Comment 5 for bug 276950

The repeated DistroArchSeries and Archive queries come mostly from SourcePackageRelease.getBuildByArch. It has a bad habit of retrieving the matching DAS for every series in the ancestry, each with a separate query. It then goes on to find every distro archive for every ancestor series... roughly three queries per ancestor per build. Those can be collapsed into a total of two queries per build. That should cut out roughly 400 of the 1400 queries in OOPS-1721E1997, which is a respectable start. A lot of the rest is to do with bug notifications.