08.12.2021 13:49, Dimitry Sibiryakov wrote:
Storing of fetched rows is unavoidable indeed but prefetch?.. Is it done in background or before returning of the first row to client even in embedded mode?
The latter. But prefetch is done in small chunks, usually it does not hurt. Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel