On Oct 1, 2008, at 9:43 AM, agatone wrote:

I'm working on a project that has big database in the background (some
tables have about 1500000 rows). We decided to use Lucene for "faster"
search. Our search works similar as all searches: you write search string, get list of hits with detail link. But there is dilemma if we should store
more data into index than it's needed.

As mentioned previously, the visual display of your search results is one rather critical factor in balancing the need to duplicate data or not...

That said... aside from some rather narrow field of endeavors... and assuming you already have a database... I would personally keep everything in there and not even bother with Lucene in the first place... after all, most databases worth using have "good enough" full text search facilities already (e.g. MySQL [1], Oracle Text [2], PostgreSQL [3], SQLite FTS [4], etc)...

In other words, do you _really_ need the full fire power of Lucene just to tack on a rather pedestrian text search on top of your small corporate database?

Just my 2ยข.

--
PA.
http://alt.textdrive.com/nanoki/

[1] http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
[2] http://www.oracle.com/technology/products/text/index.html
[3] http://www.postgresql.org/docs/8.3/static/textsearch.html
[4] http://www.sqlite.org/cvstrac/wiki?p=FullTextIndex




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to