Ann wrote:

>> ...
> Of course, SELECT ... LIMIT (111, 120) is reasonably good
> you really want just the hundred and eleventh to the hundred
> and twentieth records and don't care about 1-111. Is that
> likely?

Likely? Probably.
In a stateless situation, you don't really know what the history was.
The user might ask for the next "set" of records, the previous one, the
N'th one, or just quit.

Even though it may be'hideously slow' when implemented in the server, few
programmers will be able to make it any faster writing SPs. If the feature
is implemented we will at least not see the request any more, however there
might be request for a faster implementation :-)
(And, it will look good when comparing features)


Regards,
Aage J.