/srv/irclogs.ubuntu.com/2018/06/27/#launchpad-dev.txt

cjwatsonwgrant: Somewhere there is existing code that produces a modified field for some page or other for admins, because they have far too many options to use the normal vocabulary sensibly.  Does that ring a bell and if so do you remember where it is?00:14
cjwatsonMy grepping isn't turning up anything.00:14
wgrantcjwatson: Project owner maybe?00:17
wgrantNo, branch owner00:17
wgrantI think00:17
cjwatsonAh yeah, could be00:18
wgrantcjwatson: CodeEditOwnerMixin00:18
cjwatsonThough maybe this isn't a problem in the case at hand.  For some reason in https://oops.canonical.com/?oopsid=OOPS-bdc9d2c557980f1cad47c5bc49c51a86 BuildableDistroSeries.findSeries is deathspiralling (fair enough) but target_ppas_vocabulary isn't (weird)00:18
cjwatsonFixing the former is easy enough so maybe I'll just try that and only fix the latter if it's demonstrably a problem00:19
wgrantcjwatson: Does it get to the point where it would even materialise the latter?00:20
cjwatsonYes - make_archive_vocabulary does that00:20
wgrantHmm00:20
cjwatsonIterates through all the archives and does archive.reference etc.00:20
cjwatsonfour million people and <100000 archives though, so maybe it gets away with it somehow00:21
cjwatsonI'd have expected materialising 100000 archive rows to be worse than 300ms though.00:22
cjwatsonAnd the resulting page must be terrible ...00:24
wgrantIt is weird, unless set is taking forever for some reason on a set of 100000 identical Storm objects.00:25
wgrantWhich doesn't seem entirely likely.00:25
cjwatsonAnd anyway that would explain findSeries being slower, which I already thought was clear enough, but not target_ppas_vocabulary being mysteriously fast.00:26
cjwatsonOh well, maybe I'll see if an OOPS with the first thing fixed shows any big differences.00:29
cjwatsonIf it does then there's still room to bulkify the vocabulary construction for people like us who merely have a couple of thousand usable PPAs, and do something like CodeEditOwnerMixin for admins.00:31

Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!