Google's architecture -- was Re: paging and google.com

Google certainly doesn't use an Oracle database. They just wouldn't get the performance
that they achieve currently.
See this link on Google's architecture
: http://www.computer.org/micro/mi2003/m2022.pdf

Hemant

At 05:44 AM 26-09-03 -0800, you wrote:
>Im in the middle of Kytes new tuning book. He states that google uses a
>query similiar to this to return web pages in their search function:
>
>select /*+ FIRST_ROWS */ b.*
>from ( select a.*, a.rownum
> from (your query here) a
> where rownum < <<pick max number of rows you want in a batch >>)
>where rownum > <<will start with 1 and be max + 1 for each 'page' >>
>
>
>If they are using oracle to do this, how do they get the estimated number
>of total results? Is it from 'cardinality'? Do you know which data
>dictionary that comes from? explain plan is costly so they cant be using that.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: <rgaffuri_at_cox.net
> INET: rgaffuri_at_cox.net
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).