SQL or Lucene?
843841Nov 16 2004 — edited Nov 18 2004If 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?