https://bugzilla.wikimedia.org/show_bug.cgi?id=21675
--- Comment #6 from Jan Piotrowski <[email protected]> 2011-07-04 22:37:36 UTC --- (In reply to comment #5) > 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 There is only an index 'name_title' that is on page_namespace + page_title (only have 1.15.1 around right now). So no matter how we try, there is no way to make a well performing "Page starts with"-search ordered by last edit date? -- 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
