On 2020-04-29 18:50, Dmitry Yemanov wrote:
29.04.2020 17:50, Alex Peshkoff wrote:
Client side cursor appears not too complex at the first glance, but
not sure do we want to have client or server side cursor.
Scrollable cursor is already materialized at the server side, so I see
no point doubling efforts on the client. It should remain being
server-side.
As far as I remember MSSQL supports both types (at least that how it was
15-20 years ago).
When implementing client-side scrollable cursor client can turn off
scrollable flag for server and materialize cursor itself. I do not
insist on such solution but IMHO it can be useful at least in some
cases. It can reduce both network traffic and server load. As a dark
side use of WHERE CURRENT OF for such cursor will require additional
efforts.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel