Re: ask for a question about Lucene

[Erick Erickson <er...@gmail.com>]

My gut feel is that, with 150 records, using Lucene is overkill. This
assumes that your database already exists. You'd have to extract the data
from the DB, store it in a lucene index, then worry about keeping them
synchronized.

I'd suggest, though, that the fastest way to satisfy yourself about this
would be to create some SQL queries by hand, submit them to your database,
and measure your response time. You could get a fair idea of whether your DB
was fast enough just by this experiment.

Hope this helps
Erick

On 10/5/06, lily yan <li...@hotmail.com> wrote:
>
> Hello ALL,
>
> i'm new to Lucene and wandering where i can start from Lucene? : )
>
> basically my application is: when user input some keywords (can be more
> than
> one words) within an academic research site, the output will be the
> researchers' academic interests.
>
> there are will be a DB2 database that contains: (about 150 records in the
> table)
>
> a.  researcher's name,
>
> b. academic research interests (data type might be long varchar)
>
> c.  research description (data type might be clob)
>
> d. a field called keywords used for searching (data type varchar)
>
>    etc...
>
> a java program will do the search based on the user's input.
>
> there will be two kinds of search: basic search and advance search based
> on
> user's choice
>
> for basic search, the program will do search within the "keyword" field of
> the database.
>
> for advance search, the program will do search within the "academic
> research
> interests" field or
>
> "research description" field of the database.
>
> my questions:
>
> 1. if user choose to do basic search, does the program need use Lucene?
>
> 2. if user choose to do advance search, does  Lucene can be used to this
> scenario?
>
> i mean will the datatype of the fields of the database matter if using
> Lucene ? cause i will use both long varchar and clob.
>
> 3. is this a good idea that i choose use Lucene for my application
> scenario,
> cause the database will only have 150 records.
>
> 4. if i don't use Lucene, then basically the program will just do a
> exhustive search in the database, right?
>
> Thanks again for answering my questions,
>
> lilyyan
>
> _________________________________________________________________
> Express yourself - download free Windows Live Messenger themes!
>
> http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http://imagine-msn.com/themes/vibe/default.aspx?locale=en-us&source=hmtagline
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: java-user-unsubscribe@lucene.apache.org
> For additional commands, e-mail: java-user-help@lucene.apache.org
>
>