https://bugzilla.wikimedia.org/show_bug.cgi?id=35349
--- Comment #10 from Bryan Tong Minh <bryan.tongm...@gmail.com> 2012-03-21 20:57:43 UTC --- (In reply to comment #3) > Hi, thanks for your interest! > The output of the explain select is exactly the same if I run with or without > "mixed", are you sure it is the correct test for checking performance ? > > id select_type table type possible_keys key key_len ref > > rows Extra > 1 SIMPLE page ALL PRIMARY NULL NULL NULL 1 Using > temporary; Using filesort > 1 SIMPLE revision range usertext_timestamp usertext_timestamp > > 257 NULL 2 Using where; Using join buffer > > (and 257 becomes 271 if there is a uccontinue condition) > Yes, EXPLAIN is normally used to get an indication of the database performance. From the indices on the revision table it looks like this should work, but I think somebody who knows more about query performance should have a look at this. -- 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 Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l