MySQL full text search replacement
Moderator: General Moderators
- aaronhall
- DevNet Resident
- Posts: 1040
- Joined: Tue Aug 13, 2002 5:10 pm
- Location: Back in Phoenix, missing the microbrews
- Contact:
MySQL full text search replacement
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?
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.
Or, you can write your own
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.