MySQL full text search replacement

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
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

Post 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?
User avatar
Mordred
DevNet Resident
Posts: 1579
Joined: Sun Sep 03, 2006 5:19 am
Location: Sofia, Bulgaria

Post 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.
Post Reply