[00:00] <wgrant> Er, 23000
[00:01] <wgrant> 4000 queries to 10 for trusty amd64
[00:01] <cjwatson> Score
[00:04] <cjwatson> Tempting to get this deployed first thing tomorrow and find out.
[00:04] <wgrant> The actual query time is negligible, so we're really down to Python optimisation now if we want to go further.
[00:04] <wgrant> And at that point you might as well skip the Storm objects, since they could easily be 30% of the remaining overhead.
[00:10] <wgrant> The SSDs should also help a lot with the cold cache case, but if not we can pull some tricks with index-only scans.
[00:12] <cjwatson> Yeah, I guess my 17043 runs weren't really cold cache to start with
[00:15] <cjwatson> cron.ppa's two publish-distro runs combined averaged 656 seconds in the 99 runs in today's log file
[01:41] <wgrant> cprov: https://code.launchpad.net/~wgrant/launchpad/bug-1083709/+merge/222895
[01:57] <cprov> wgrant: on it
[02:02] <cprov> wgrant: now, isDriver(IPerson) works for IHasDriver and IHasDrivers ?
[02:03] <wgrant> cprov: Right. isOneOfDrivers always did, but there's no reason for isDriver to not also consider .drivers.
[02:03] <cprov> wgrant: looks sensible, I don't get the old isOneOfDrivers() ...
[02:05] <wgrant> cprov: Thanks
[02:09] <wgrant> cprov, cjwatson: I'm tagging possibly-RTM-relevant bugs "phone-rtm"
[02:10] <cprov> wgrant: okay
[02:10] <cprov> wgrant: will we consider the ppa publisher scale a problem for rtm ?
[02:11] <wgrant> cprov: No, but it'
[02:11] <wgrant> s mostly fixed now anyway.
[02:11] <wgrant> RTM isn't going to use any significantly sized PPAs.
[02:12] <cprov> right, the derived-distros is a way of avoiding huge PPAs
[02:13] <cprov> but it kind of hold us a little more to a-f
[02:13] <wgrant> No more than Ubuntu does.
[02:17] <cprov> true
[05:19] <stub> lifeless: pytz.FixedOffset(minutes), which never seemed to make it into the README
[05:19] <lifeless> stub: AHHA
[05:19] <lifeless> stub: <3
[08:55] <cjwatson> cprov: We identified PPA publishing performance as an issue when figuring out what to do for RTM, but it wasn't the reason we decided to use a derived distribution instead.  The reason for that was that PPAs are insufficiently isolated from their parent distribution: they still use the parent in builds, and chroots aren't archive-specific.
[08:56] <cjwatson> The model works better if we split out an entire new series.
[12:53] <cprov> cjwatson: I see, thanks for contextualising it.
[18:35] <lifeless> cprov: any chance, if I file a bug, that adding specs via the API would be done soon ?
[18:35] <lifeless> cprov: it looks like bugs are adding via the /bugs collection, but there is no /specifications top level collection, so the createSpecification method isn't exposed
[18:36] <lifeless> wgrant: ^ if you happen to be in an awake state before cprov answers :))
[18:36] <cprov> lifeless: I can certainly look at it and figure out how much effort would be involved
[18:37] <lifeless> cprov: that would rock :)
[18:37] <cprov> lifeless: cool, *bug* me and I will discuss it later with wgrant
[18:39] <lifeless> cprov: wicked - thanks! https://bugs.launchpad.net/launchpad/+bug/1329424
[18:39] <_mup_> Bug #1329424: cannot create specification via API <Launchpad itself:New> <https://launchpad.net/bugs/1329424>