https://bugzilla.wikimedia.org/show_bug.cgi?id=30252
--- Comment #2 from Max Semenik <[email protected]> 2011-08-08 07:04:49 UTC --- Created attachment 8896 --> https://bugzilla.wikimedia.org/attachment.cgi?id=8896 indexes and so on No surprise since it tells you in nice boldtext: "This page is disabled." Wikimedia wikis are running in miser mode and this page is slow as hell on large datasets. Here's my proposed fix that: 1) Adds index for MIMESearch queries 2) Sorts by image name instead of major mime type which was pointless anyway It nukes filesort and full-table scan, but still I would like a MySQL ninja to confirm that these changes are enough to allow using this page in miser mode. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
