hi, I just recently study about hibernate search, great tool for simplify search in database.

so my question is, how do we decide to choose which method for search ? SQL or directly using hibernate search, any advantages and disadvantages ?
(I think is sound like compare hibernate and JDBC :) )

In which circumstance we should use one instead of the other ?

Say i had a search that require some number comparison like price etc, should I use SQL directly or use Hibernate search with range filter (like the hibernate search doc recommended)?

how the performance, which one is faster ?

any idea ?

kiwi

Hello,


the answer is of course "it depends"; you should understand what a fulltext search is;
Hibernate Search is most suitable when you want to search in free text, in particular when you need features as "text should contain some of these words" or "a phrase which looks like this one", a bit "search engine like".
If you only have to check against price ranges, then you should use standard queries.


The performance for fulltext searches using Search is great, but hey are difficult to compare as they actually solve different problems. There are some cases in which you could do the same stuff with both, but they are limited and depending on the use case it should be obvious which one is more appropriate; the most appropriate will always be the best performer for the task.

I would suggest you to get a better understanding about fulltext searches, and all pros and cons with the new book which is being released:
http://blog.emmanuelbernard.com/2008/02/hibernate-search-in-action-book.html

ok.. thx !

kiwi