lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ben Litchfield <...@csh.rit.edu>
Subject Re: name search from Oracle to Lucene
Date Tue, 13 May 2003 16:08:53 GMT

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


Mime
View raw message