Yep, my advice always is use a db for what a db is designed for (set
manipulation) and use Lucene for what it is good for, but some people
were commenting that DB text search is improving in terms of quality.
I could see that if flex. indexing gets implemented, that we could
implement other storage algorithms that could then be chained to
provide better storage mechanisms for structured data while
maintaining the inverted index for text...
-Grant
On May 7, 2007, at 6:50 PM, Ian Holsman wrote:
Grant Ingersoll wrote:
2. How does Lucene search compare w/ using built in DB search? Has
anyone done a study comparing Lucene performance/quality to the
likes of MySQL/Postgres/Oracle? Related question is always on how
to integrate the two.
Hi Grant.
when we initially investigated using lucene at a previous company I
worked for, we went into this in a great deal.
To summarize the results (I don't have access to the slides/report
now).
lucene/solr had better functionality/quality results for
unstructured searching than mysql did at the time. (speed was
comparable, and was not a deciding factor)
for structured-data searches we found mysql did a better job.
on how to integrate the two? in the ingestion phase you would emit
2 updates to two separate sources. The developer could then choose
which search service (structured or unstructured) best suited their
needs and use that. (and do any joins required on the client side).
regards
Ian
-Grant
--------------------------
Grant Ingersoll
Center for Natural Language Processing
http://www.cnlp.org/tech/lucene.asp
Read the Lucene Java FAQ at http://wiki.apache.org/jakarta-lucene/
LuceneFAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------
Grant Ingersoll
Center for Natural Language Processing
http://www.cnlp.org/tech/lucene.asp
Read the Lucene Java FAQ at http://wiki.apache.org/jakarta-lucene/
LuceneFAQ
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]