Comment 1 for bug 475435

I can't get to this page at all at the moment. The problem seems to be mostly non-SQL time, so we could use some profiling on the app server.

The query log looks very different today from when this bug first came up: we seem to count the POTMsgSets and Languages connected to a template (through TranslationTemplateItems and POFiles, respectively). Secondary to that we're also querying a lot of Persons. These queries could easily be made to run faster—there's no need why POTMsgSet and Language should be in those queries at all. But that's not going to help the non-SQL time, and these are very fast queries. Batching them would do more, but whether that would address the main source of non-SQL time would be just a guess.

One thing we *can* tell from the query log is that the non-SQL time is interspersed seemingly randomly through the rendering of the templates list. And that makes this a perfect candidate for TAL fragment caching.