| • bzimport | |
| Sep 1 2008, 4:00 AM |
| F5228: my.patch | |
| Nov 21 2014, 10:23 PM |
Author: soxred93
Description:
Patch for special page
Similar functionality to Special:Prefixindex, this special page looks for text at the end of a page title, instead of the beginning.
Version: 1.13.x
Severity: enhancement
attachment my.patch ignored as obsolete
soxred93 wrote:
Add the actual page :)
Somehow, svn diff forgot the special page itself.
Attached:
river wrote:
this looks far too slow for any medium or large site; a query of the form LIKE '%foo' can't be indexed, it does a full table scan.
one way to do this efficiently would be to store a list of all titles in reverse order (i.e. "Wikipedia" -> "aidepikiW") and do a prefix index with the reversed query (LIKE "%edia" -> LIKE "aide%") - such a query can be indexed as the initial part of the string is static.
of course, this would need some kind of maintenance script to produce the initial title list.
I don't think we want extra indexes or maintenance scripts for such a rarely requested and apparently pointless feature.