Eyes on Final Fantasy Forums > Reference > General Archive > Feedback Forum Archive > Search results sorting

[Endless]

BoB..

And the mome rath cl_out outgrabe:

I'm talking about mysql's built-in fulltext index

[Loony BoB]

You still all suck and so does clout in that case. Since this discussion has been based on searches on posttext, you don't need to do partial searches in the database itself if you can do them right here in the forums.

[Endless]

The idea behing the built-in text index is that it allows natural search, i.e., if I searched for "caike", it would also return posts containing "cake". Besides, I wouldn't be surprised if the built-in full index took less space than vB's search index.

[Loony BoB]

A spellchecking search? o_o

[Flying Mullet]

Hey, quit molesting my thread and get back on topic! This thread is about sorting, not search indexes.

[Loony BoB]

Wait until vB3.5.0 and then we'll talk about any changes to code. It should be within the next six months. But for now, the answer to the original question is 'no'.

[Samuraid]

And the mome rath Endless outgrabe:

The idea behing the built-in text index is that it allows natural search, i.e., if I searched for "caike", it would also return posts containing "cake". Besides, I wouldn't be surprised if the built-in full index took less space than vB's search index.

Ah, so fulltext does use relevancy matching...that almost negates the need for metaphone keys. Very cool, thanks for checking that out Endless.