Launchpad itself

~canonical-launchpad-branches/launchpad/+git/bzr-personal:cjwatson/optimise-filelists

  1. Git
  2. lp:~canonical-launchpad-branches/launchpad/+git/bzr-personal
  3. cjwatson/optimise-filelists
Last commit made on 2014-07-17
Get this branch:
git clone -b cjwatson/optimise-filelists https://git.launchpad.net/~canonical-launchpad-branches/launchpad/+git/bzr-personal
Members of Canonical Launchpad Branches can upload to this branch. Log in for directions.

Branch merges

Branch information

Name:
cjwatson/optimise-filelists
Repository:
lp:~canonical-launchpad-branches/launchpad/+git/bzr-personal

Recent commits

e33f4aa... by Colin Watson

Ask the DB to sort filelists by component and architecture and then write a group at a time directly, rather than building a dict of dicts of lists first.

fea5831... by Colin Watson

Stop asking the DB to prepend "binary-" to architecture names several hundred thousand times and then sometimes remove it again in Python, when we can just as well prepend it once per component/architecture when we need it.

519f7d6... by Launchpad PQM Bot

[r=wgrant][no-qa] Optimise phase A2 of the publisher by searching for
 to-be-deleted source and binary publications in one query each,
 rather than one per active distro(arch)series and pocket.

7ae4eda... by Colin Watson

Don't bother materialising xPPHs that we aren't going to use.

3e6964f... by Launchpad PQM Bot

[r=wgrant][no-qa] Merge db-stable r12750 (xPPH(archive,
 status) WHERE scheduleddeletiondate IS NULL indices).

3f16449... by Colin Watson

Optimise phase A2 of the publisher by searching for to-be-deleted source and binary publications in one query each, rather than one per active distro(arch)series and pocket.

44ec0b1... by Launchpad PQM Bot

[r=wgrant][no-qa] Add xPPH(archive,
 status) WHERE scheduleddeletiondate IS NULL indices,
 to help speed up step A2 of the publisher.

8e1ff19... by Colin Watson

Drop dateremoved IS NULL condition; it's almost implied by scheduleddeletiondate IS NULL, and it should be possible to make the implication complete soon.

5d2f7b9... by Colin Watson

Add xPPH(archive, status) WHERE scheduleddeletiondate IS NULL AND dateremoved IS NULL indices, to help speed up step A2 of the publisher.

89bfe08... by Launchpad PQM Bot

[rs=buildbot-poller] automatic merge from stable. Revisions: 17112
 included.