On Tue, 25 Feb 2003 PinkeshP@stripped wrote:
> I wanted to created a searh engine for our site with indexed content of
> the pages being stored in MYSQL full text index. I wanted to know how
> fulltext index scales if I have about 200,000 pages indexed. Is it wise
> to use MYSQL for this or go with other options like SWISH-e etc.
we have about 2x 200 MB of indexed text data (*.MYD files only)
representing 30'000 documents and our testruns peak at 50 fulltext queries
per second. This is on a Linux box with a single Pentium-4 and 1 GB RAM.
As long you are generous enough with RAM your database may deliver much
more data than your bandwith can transmit unless you have a very good
Perhaps you provide us with some more details about your setup; otherwise
you can't expect more specific answers.
sql, query (filter-food)