Last modified: 2012-07-30 09:06:41 UTC
Can take 10s seconds. 1) translate_groupstats is missing index on tgs_lang 2) language building is slow, should use special value to signal "all languages" 3) smaller issues in getGroupLabel and other places
CREATE INDEX /*i*/tgs_lang on /*_*/translate_groupstats (tgs_lang); https://gerrit.wikimedia.org/r/15860
2) https://gerrit.wikimedia.org/r/#/c/15873/ 3) https://gerrit.wikimedia.org/r/#/c/15879/ https://gerrit.wikimedia.org/r/#/c/15878/ These should improve the performance back to acceptable levels for now.