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.

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).


Dmitry