partsi wrote:
Does Firebird support retrieving multiple records in a single call? I would expect Firebird to provide a function such as `isc_dsql_fetch_n` to retrieve multiple records. This would improve performance with larger result sets because the number of roundtrips to the server could be minimized.
Dmitry Yemanov answers:
Firebird does it behind the scenes. A fetch call retrieves multiple records (as many as fits in the protocol packet) and they're cached on the client side to be used by subsequent fetch calls (until the cache is empty and another roundtrip is made).