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
feed.
Perhaps you provide us with some more details about your setup; otherwise
you can't expect more specific answers.
Thomas Spahni
--
sql, query (filter-food)
int a=10000,b,c=2800,d,e,f[2801],g;main(){for(;b-c;)f[b++]=a/5;
for(;d=0,g=c*2;c-=14,printf("%.4d",e+d/a),e=d%a)for(b=c;d+=f[b]*a,
f[b]=d%--g,d/=g--,--b;d*=b);}
