lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leo Galambos <Le...@seznam.cz>
Subject Re: commercial websites powered by Lucene?
Date Wed, 25 Jun 2003 17:16:51 GMT
>
>
>BUT, looking at the Full text indexing/searching part...it 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?

-g-



---------------------------------------------------------------------
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