Subject Re: [firebird-support] Fetch multiple rows using isc_dsql_fetch
Author Dimitry Sibiryakov
On 26 Feb 2006 at 23:28, kapsee wrote:

>isc_dsql_fetches only a single row at a time. Does this require a new
>round trip to the database for every row ?

Not always. Unless you use SELECT FOR UPDATE, records in result set
are batched up to size of TcpRemoteBufferSize.

>How do I optimize this ?

Try to increase TcpRemoteBufferSize.

--
SY, Dimitry Sibiryakov.