At 03:28 PM 5/30/2001 -0400, David Jencks wrote:

>Since it is remarkably easy to implement, perhaps you would let on where
>you would put it. For limit (n, m) would you just fetch rows up to m and
>discard the first n-1 of them? If this is in the client, wouldn't it be
>equally fast to let the user discard the first n-1 rows? Where does the
>parsing to recognize the request happen?

There's already code in the engine to limit the number of rows returned,
but no code to handle a request that says "give me rows 21 to 30." It
could be done, hideously inefficiently, on the server side, I suppose, but
it would require lots of changes.


Regards,

Ann
www.ibphoenix.com
We have answers.