lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From david chan <david_tom...@yahoo.com>
Subject Re: name search from Oracle to Lucene
Date Tue, 13 May 2003 18:36:33 GMT
Function index will solve my problem easier.

Thanks.
David

--- Ben Litchfield <ben@csh.rit.edu> wrote:
> 
> Not to veer you from lucene but have you tried
> Oracle's function based
> indexes which can use an index for like and upper.
> 
> Examples are here
> http://osi.oracle.com/~tkyte/article1/index.html
> 
> Ben
> 
> 
> 
> On Tue, 13 May 2003, david chan wrote:
> 
> > Hi,
> >  I have a table with more than 1 million records,
> I
> > need to some search on these three fields:
> firstname,
> > lastname, nickname
> >  Now when I try to search these names from Oracle
> with
> > some keyword "like%", or function for "upper" to
> > ignore case compare, these kind of query become
> very
> > slow even these name fields are indexed. One
> reason is
> > because these function "like", "upper" not using
> the
> > index.
> >  I wonder it can be done better in Lucene, anyone
> can
> > give me some idea how name search (partial name
> > search, firstname search, lastname search,
> nickname
> > search, or combination search) can be done?
> >  I am thinking to dump this big oracle table to a
> > plain text file, then read in and index by using
> > Lucene. But now sure how to arrange these fields
> to
> > get a good/fast result.
> >
> > Thanks.
> > David
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> lucene-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> lucene-user-help@jakarta.apache.org
> >
> 
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> lucene-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> lucene-user-help@jakarta.apache.org
> 


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: lucene-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: lucene-user-help@jakarta.apache.org


Mime
View raw message