Thanks for the info.

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.

(Aside, IRowset::GetNextRows allows the caller to retrieve multiple
rows (records) but this is not much helpful in terms of performance if
the database engine does not support this feature.)

Partsi