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 Witten, Moffat, and Bell.
On Wed, Apr 11, 2001 at 09:23:53AM -0700, Heath Boutwell wrote:
> 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 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 question:
>
> How is it all done so quickly?
>
> Any thoughts or theories appreciated.
>
> __________________________________________________
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Tom Kleinpeter
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php