Subject Re: How to convert set of integers into a BLOB in SP or UDF
Author Roman Rokytskyy
> >Will Firebird somehow optimize each isc_dsql_fetch somehow that it
> >will transmit 120 records per packet instead of 120 packets for each
> >record?
> Yes. Unless your select includes "FOR UPDATE" (that's a long sorry
> story), the server prefetches records to fill a packet. The client
> dll returns the records to the client one at a time.

Now let's consider the case of JayBird. Since no dll is available (we
talk wire protocol there), do we need to send something to server, so
we get response in one packet? Or we get response in such form in all