Page 1 of 1

MySQL full text search replacement

Posted: Sat Oct 07, 2006 7:35 am
by aaronhall
Can you guys recommend a good MySQL full text boolean search replacement? The four letter indexing limit is killing me. I'm looking at PhpDig as an alternative -- any others you know of?

Posted: Sun Oct 08, 2006 10:43 am
by Mordred
AFAIK the indexing limit can be lowered (at the cost of increasing the index though), which may be enough for you.
Or, you can write your own ;) Build a inverted index of the texts you need, and then the boolean operations are identical to set operations with the inverted index entries about the words in the query.

I've built a proximity text search engine with a trivial extension of this system and it's working fast enough even for megabyte documents.