Implement Special:Suffixindex page
Closed, DeclinedPublic

Description

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

bzimport added a subscriber: wikibugs-l.
bzimport set Reference to bz15412.
bzimport created this task.Via LegacySep 1 2008, 4:00 AM
bzimport added a comment.Via ConduitSep 1 2008, 4:02 AM

soxred93 wrote:

Add the actual page :)

Somehow, svn diff forgot the special page itself.

Attached: my.patch

bzimport added a comment.Via ConduitSep 1 2008, 4:54 AM

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.

tstarling added a comment.Via ConduitSep 1 2008, 5:11 AM

I don't think we want extra indexes or maintenance scripts for such a rarely requested and apparently pointless feature.

Add Comment

Column Prototype
This is a very early prototype of a persistent column. It is not expected to work yet, and leaving it open will activate other new features which will break things. Press "\" (backslash) on your keyboard to close it now.