HGeneAnthony Posted July 27, 2008 Share Posted July 27, 2008 I'm interested in implementing a fulltext search for my site and I'm trying to decide between 2 different ones. First is MySQL's native fulltext search. The perk is it's native and offers limits to results returned. It's negatives is that it can't use innodb tables, doesn't offer half of the available functions of Lucene's search, and it doesn't tokenize a field so to get an accurate result if you have 30 keywords you need 30 fields. I also hear it's slow for large results. Then we have Lucene. Lucene is part of the Zend framework and offers a standalone index. The perks are it's fast and feature rich. It also tokenizes fields. It's negatives are that it (as far as I've seen) only returns full results not limits and that I need to maintain something else for my site when MySQL offers a native solution. I'm wondering what opinions others have about this topic. Quote Link to comment Share on other sites More sharing options...
tibberous Posted July 27, 2008 Share Posted July 27, 2008 Your overthinking it. Just use the first option, "... where name like 'bob%'" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.