27.11.2021 15:04, Dimitry Sibiryakov wrote:

I would consider adding a NO_BATCH flag (which is currently triggered using FOR UPDATE syntax) to cursorFlags.

That would be useful in some cases. And if statements with "WHERE CURRENT OF" condition also were somehow marked client libraries could force cursor position synchronization before executing them.

I'd expect FOR UPDATE to still disable batching even without that NO_BATCH flag (as now), just because I can hardly see the need to prefetch cursor (and later reposition) if a positioned UPDATE/DELETE is expected.


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to