Home » SQL & PL/SQL » SQL & PL/SQL » How does google do pagination while showing # of results? (8i)
How does google do pagination while showing # of results? [message #318386] Tue, 06 May 2008 13:43 Go to next message
Oemprise
Messages: 2
Registered: May 2008
Junior Member
I have successfully implemented pagination by using rownum in my queries. A query returns only 10 results, and when I click next it gathers the next 10 and so on.

When I do a google search for "google" (for example), I can see 10 results, and I also see that there are about 2,460,000,000 total results. I am assuming google does not actually get the data from that many results in 0.05 seconds. Does it do a count that is somehow much faster than getting result information, or is that number coming from somewhere else?

I would like to accomplish something like this, if anyone knows how it is done.

Thanks.
Re: How does google do pagination while showing # of results? [message #318390 is a reply to message #318386] Tue, 06 May 2008 14:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AskTom: getting rows N through M of a result set, search for google.

Regards
Michel
Re: How does google do pagination while showing # of results? [message #318409 is a reply to message #318386] Tue, 06 May 2008 15:35 Go to previous message
Oemprise
Messages: 2
Registered: May 2008
Junior Member
Thanks, it was an interesting read.
Previous Topic: Trigger problem with nested query
Next Topic: failed to retrieve data from all_views from pl/sql
Goto Forum:
  


Current Time: Sat Dec 03 13:51:47 CST 2016

Total time taken to generate the page: 0.05944 seconds