lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leo Galambos <>
Subject Re: commercial websites powered by Lucene?
Date Wed, 25 Jun 2003 17:16:51 GMT
>BUT, looking at the Full text indexing/searching not up to snuff.
>Currently, I'm using mysql's full text search support. I have a database of
>3-5 million rows. Each row is unique, let's say a product. Each row has
>several columns, but the two I search on are title and description. I
>created a full text index on title and description. Title has approximately
>100 characters, and description has 255 characters.
store the two columns in an extra table. it would help you.

>At the moment, mysql is taking 50 seconds plus to return results on simple
>one word searches. My dedicated server is a P4, 2.0 Gighz, 1.5 Gig RAM
>RedHat Linux 7.3 platform, with nothing else running on it, i.e. another
>server is handling HTTP requests. It is a dedicated mysql box.  In addition,
>I'm the only person making queries.
did you write it to mysql team?


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message