Re: Skipping records from a Cursor

ah_mostin_at_yahoo.com wrote:
>
> 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 ?

It can't be done directly. It says so right in the RTFM documentation. I guess I don't understand why this issue keeps coming up. The documentation is very clear on this and I doubt whether Oracle will ever add this functionality because of the tremendous overhead that would be required in the engine. Received on Mon Jan 29 2001 - 07:45:30 CST