Page MenuHomePhabricator

Restructure searchindex table for performance
Closed, DeclinedPublic

Description

As per recommendations at: http://wp.wikidev.net/Schema_change_2004-08_searchindex

May also want to backport to 1.3 [as an experimental option] to get this running on Wikipedia asap.


Version: 1.4.x
Severity: enhancement

Details

Reference
bz437

Event Timeline

bzimport raised the priority of this task from to Lowest.Nov 21 2014, 6:55 PM
bzimport added a project: MediaWiki-Search.
bzimport set Reference to bz437.
bzimport added a subscriber: Unknown Object (MLST).

Want to get this up and running.

zigger wrote:

Is this the new Lucene search, or does Lucene supersede this restructuring?

I'd say the Lucene search pretty well obsoletes this, as it's much more efficient than
MySQL's search on large sites. On small sites it doesn't have to be terribly efficient,
and the simplicity of the current schema is probably easier to deal with.

WONTFIXing this unless someone really wants to defend (and do) it.