Re: Skipping records from a Cursor

In our last gripping episode Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> 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.
>

Yet 9i is slated to contain incremental query support which, I believe, satisfies the poster's criteria.

At least that is the word from Oracle...

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/