Re: Skipping records from a Cursor

If you really want to scroll them all, I suppose you construct an array in memory and remember all those primary keys. It would indeed be interesting to know how Yahoo/altavista solved it.

<ah_mostin_at_yahoo.com> schreef in bericht news:94t8dt$s3o$1_at_nnrp1.deja.com...
> I want to be able to provide paging functionality in a Java/web
> application without keeping a database connection permanently open due
> to scalability issues.
>
> For example query returns a 100,000 records, on a page I wish to
> display only 1000 with next/back buttons. When the back next button is
> pressed I want to retrieve the rows 1001->2000. Like I said I don't
> won't to retain the database connection between pages so using a
> scrollable resultset is out of the question.
>
> How do I tell Oracle I only want n -> n+1000 records without having to
> fetch and ignore previous records.
>
> How do yahoo/altavista etc implement this type of paging functionality
> given the thousands of concurrent users ?
>
> Any help would be much appreciated.
>
> mostin
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Mon Jan 29 2001 - 07:14:45 CST