The team page makes a lot of queries to the database, and not all of them are necessary. Some of those are also in shipping.api. Let's make some progress on those before we dive too deep into porting that logic over to other views in bug 1111570.
Commits pushed to develop at https://github.com/mozilla/elmo https://github.com/mozilla/elmo/commit/607bfee55dff3d6d8fe31bebb179fcff3f2c7547 bug 1188833, optimize team page. Refactor more queries outside of the for loop and gather the data upfront. https://github.com/mozilla/elmo/commit/836b2953a7ab9e9994435d33c495508526af5640 bug 1188833, rework fallback logic in shipping.api There's a bunch of fixes in this patch. Firstly, if we got an appversion covered, don't evaluate it again. Then, once we're falling back, make sure we're only trying locales that actually had an ACCEPTED signoff in our fallback chain. That way, our iteration actually comes to a rather early and good end.