originale-
Da: Fantry, John [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 19 luglio 2006 21.01
A: Derby Discussion; [EMAIL PROTECTED]
Oggetto: RE: Paginating result sets
I have tried a scrollable cursor and it is way too slow. The
'absolute()' method on the ResultSet object takes so
Fantry, John wrote:
I have tried a scrollable cursor and it is way too slow. The
'absolute()' method on the ResultSet object takes so long to return I
have to show an hour glass icon and the user has to wait an eternity.
In this case the result set had over 2 million rows. I have a
I need some help
figuring how to paginate result sets with Derby. Ihave scanned the
list archives and have found one similar thread that never received a complete
answer from May 2005.
From what I
understand this pagination behavior is possible in MySQL by using the 'LIMIT'
query. This
Did you try to use a scrollable cursor?
Or how about storing your result set in to a temp table with some sort of row
id?
Both of these solutions are pretty much database independent, assuming of
course that they support the concept of cursors...
If you're going to use either solution, you're