Subject Re: [Firebird-Architect] Re: Bi-directional indexes
Author Jim Starkey
Nando Dessena wrote:

>D> As for the FIRST/SKIP problem, I'd say this is easily solvable on
>D> the client or in PSQL via an open cursor and explicit fetches. Do I
>D> miss something important in this wish?
>they want to do it stateless, in different transactions if not
>different attachments, with not much regard for accuracy, mostly from
>web applications. That's what people appear to need.
Web applications and client/server applications are totally different
animals. In client/server, you know you have a connection to a client
application that's presumably talking to a human. If he asks for a
multiple page display, you can be reasonable assured that he'll either
ask for them or for something else, in which case, cached data can be
flushed. In the web world, there is no connectivity to a client and
each page is an atomic operation. What the user might do or if we will
even hear about it is unknowable.