Alex Rivera | Logout

Search engine Lucene vs Database search

Asked 2011-01-09T10:22:47.660
43

I am using a MySQL database and have been using database driven search. Any advantages and disadvantages of database engines and Lucene search engine? I would like to have suggestions about when and where to use them?

mysql lucene search-engine
Edit
Report

1 Answer

36

I suggest you read Full Text Search Engines vs. DBMS. A one-liner would be: If the bulk of your use case is full text search, use Lucene. If the bulk of your use case is joins and other relational operations, use a database. You may use a hybrid solution for a more complicated use case.

answered 2011-01-09T12:03:53.827

Your Answer