Re: the quick and the dead...

2001-04-11 Thread Heath Boutwell
Thanks for the information below. Also, according to the article here: http://www.webtechniques.com/archives/2001/05/hong/ The wildly popular amihotornot.com has served over 17.5 million page views in one month using mySQL exclusively. I don't know how extensively Yahoo Finance uses mySQL in th

Re: the quick and the dead...

2001-04-11 Thread Tom Kleinpeter
This is not done with a RDBMS. I don't think any commercial, general purpose database is designed to search over a billion documents at that speed. Text search engines like Google and Altavista are designed with a lot of different goals. A good book on the subject is "Managing Gigabytes" by

Re: the quick and the dead...

2001-04-11 Thread Steve Werby
"Basil Hussain" <[EMAIL PROTECTED]> wrote: > Anyway, 405 queries per second is not so much if you have monster hardware. > I seem to remember one of the MySQL developers mentioning one time that they > had benchmarked a MySQL server at over 1,000 queries/sec. Though a MySQL benchmark may have ach

Re: the quick and the dead...

2001-04-11 Thread Basil Hussain
Hi, > 35 Million keyword searches a day are done at the > Goolge site. > > My calculator tells me this is roughly 405 keyword > searches per SECOND. > > Not even considering any other database queries needed > to generate targeted ad placement on each page, etc > one is left with a haunting que

Re: the quick and the dead...

2001-04-11 Thread Steve Werby
"Heath Boutwell" <[EMAIL PROTECTED]> wrote: > According to a recent story: > http://news.cnet.com/news/0-1005-200-5561996.html?tag=tp_pr > > 35 Million keyword searches a day are done at the > Goolge site. > > My calculator tells me this is roughly 405 keyword > searches per SECOND. > > Not even c

the quick and the dead...

2001-04-11 Thread Heath Boutwell
Since mySQL is one the fastest RDBMS in the world for pure SELECTs, this seems like the proper forum to pose the following: According to a recent story: http://news.cnet.com/news/0-1005-200-5561996.html?tag=tp_pr 35 Million keyword searches a day are done at the Goolge site. My calculator tell