Dimtry,
Just compiled the updated master branch and tested with IBX. All looks
good with the test suite returning the same set of results for bot
remote and local databases.
Many thanks for the good work.
I've noticed that the ODS is now 13.1 compared with 13.0 for Firebird
4.0.0. Is this due to your patch or have there been other changes that
have needed this?
Regards
Tony Whyman
On 26/11/2021 09:10, Dmitry Yemanov wrote:
Mark et al,
Yes, I think that is perfectly acceptable for an initial version.
Scrollable cursors are a bit of an oddity anyway, but having
scrollable cursors in embedded access, but not in remote access is
IMHO less acceptable than bad performance. As long as the performance
behaviour is clearly documented, people can make the decision if the
bad performance is worth the utility of scrollable cursors for
themselves.
I've just committed network support for scrollable cursors to master.
Prefetch logic is supported for NEXT/PRIOR navigations. Protocol
changes are documented here:
https://github.com/FirebirdSQL/firebird/issues/7051
The test set to cover different navigation scenarios is being created,
once it's ready we'll validate the results between PSQL cursors,
embedded access, network access w/prefetch and network access
wo/prefetch (FOR UPDATE added to SELECTs). Obviously, we expect them
to match ;-)
I'd appreciate if Mark could test scrollability from the Jaybird side
too (i.e. without fbclient involved), but the new protocol should be
supported for that.
The committed version is linked to protocol 17 which was introduced
for 4.0.1. Thus technically, this improvement can be backported and
released together with v4.0.1. However, I'm not sure this risk is
acceptable for a point release and I'm ready to introduce protocol 18
in master for v5. Opinions, please.
Dmitry
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
