Craig L Russell wrote:
What Derby does to support paging is to allow you to collect the thousands of rows, sorted, on the server, and then use JDBC to page through the results. You only do the big inner select once and then go page through them.
How? Can you explain further, please? (This thread is related to a number of similar questions I've asked in the recent past, and I'm still no closer to a workable solution, but this sounds potentially helpful.) ----------------------------------------------------------------- John English | mailto:[EMAIL PROTECTED] Senior Lecturer | http://www.it.bton.ac.uk/staff/je School of Computing & MIS | ** NON-PROFIT CD FOR CS STUDENTS ** University of Brighton | -- see http://burks.bton.ac.uk -----------------------------------------------------------------
