Subject | Re: Cursors |
---|---|
Author | Miroslav Halas |
Post date | 2004-06-04T13:50:37Z |
>Roman,
> > Is it possible, already, to use cursors in Jaybird 1.5?
> > rs.absolute(n); rs.last();
>
> Yes, in version 1.5 RC3 when you use
> ResultSet.TYPE_SCROLL_INSENSITIVE. But beware of the fact that it
> cashes complete result set on the client, this needs memory. Also when
> using this feature no "UPDATE ... WHERE CURRENT OF ..." is possible.
>
> Roman
>
can you then suggest solution if I have table with let say 100,000
records and I want to display record 50,000 - 50,010? How to do it
effectively and fast?
Miro