https://bugzilla.wikimedia.org/show_bug.cgi?id=16967
Aryeh Gregor <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |m --- Comment #2 from Aryeh Gregor <[email protected]> 2009-02-05 00:33:38 UTC --- The query should just use rev_timestamp. It would have to discard most of the rows, but it would probably be a lot faster than the filesort. The current query seems to be taking a half-second on enwiki, according to forceprofile=true. Since views don't support FORCE INDEX, though, I can't test the alternative version on a real database. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
