https://bugzilla.wikimedia.org/show_bug.cgi?id=21675
--- Comment #5 from Roan Kattouw <[email protected]> 2011-07-04 19:14:53 UTC --- (In reply to comment #4) > Didn't think about that. So I assume what you mean is that a (MySQL) > LIKE-Search on page_title when ordered by page_touched isn't an option? Assuming an index on (page_title, page_touched): (I don't believe such an index actually exists.) WHERE page_title = 'Foo' ORDER BY page_touched; --GOOD WHERE page_title LIKE 'Foo%' ORDER BY page_touched; --BAD WHERE page_title LIKE 'Foo%' ORDER BY page_title, page_touched; --GOOD -- 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
