Last modified: 2012-07-30 09:06:41 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T40456, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 38456 - Special:LanguageStats is super slow
Special:LanguageStats is super slow
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Translate (Other open bugs)
unspecified
All All
: Unprioritized normal (vote)
: ---
Assigned To: Niklas Laxström
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2012-07-17 22:35 UTC by Niklas Laxström
Modified: 2012-07-30 09:06 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Niklas Laxström 2012-07-17 22:35:55 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
Comment 1 Sam Reed (reedy) 2012-07-18 01:10:39 UTC
CREATE INDEX /*i*/tgs_lang on /*_*/translate_groupstats (tgs_lang);

https://gerrit.wikimedia.org/r/15860
Comment 2 Niklas Laxström 2012-07-30 09:06:41 UTC
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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links