Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL or Lucene?

843841Nov 16 2004 — edited Nov 18 2004
If i have a website where a listing such as autotrader.com (about the same amount of information you see for each car listing) is searched by a users via a jsp page would that be a job for Lucene or SQL? Also considering that the description of each listing is no more than say 100 characters...if that makes any difference.

and if it's a job SQL can handle; when searching a database (select blah from table where THIS like That) [I know that's wrong just example] would SQL return the results in any kind of order?

eg. like someone searched for "Java Documents" and there were three listings searched through, one had "Java Documents" one had "java" and another had "documents"; would SQL give the results as a best match? or just return all that had either word?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2004
Added on Nov 16 2004
7 comments
287 views