db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From J.Engl...@bton.ac.uk
Subject Re: Using/Adressing a "row number" in a SELECT query
Date Thu, 23 Feb 2006 13:42:32 GMT
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:je@brighton.ac.uk
  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
-----------------------------------------------------------------

Mime
View raw message