hi, I plan to add a search function to my website.

The parameters is consist of text and number (compare number higher, smaller, between), which is the more suitable solution this use case ?

I found that both way also can implement (not so difficult), but wondering which is the better approach on performance and code maintaining perspective .(like able to add more search parameters or modify the parameter etc).

If using hibernate search, It seem like a lot work to be done in compare numbers, since Lucene is only know string.

any idea ?

kiwi
----
happy hacking !

Hi,
yes you are right if all search parameters are numbers then Lucene (and Hibernate Search) would be more difficult to use and maintain than plain HQL/SQL;
However it really rocks if you need (or foresee you will need) to add full text search capabilities.
You may like the book (in the banner of the forum) for good guidelines from Emmanuel, it's not published yet but you can already download most chapters you're needing for this type of decisions.

regards,

hi, thx for rely.

Indeed I like to use Lucene for it powerful features (and lazy to come out my half bake solution, or worst implementation :) ). maybe i will look at the filter.

not sure if hibernate search will add support for SQL + Lucene search in future like this :

//get the easy job in SQL or HSQL
ResultSet rs = session.createSQL("select * from table where xx <3 and yy > 4;");

//then apply Lucene search on the Result set.
FullTextQuery hibQuery = fullTextSession.createFullTextQuery( query, rs, SomeClass.class);

then it will be easy a lot to implement search on specific item.

kiwi
----
happy hacking !