At 04:37 PM 12/1/2002 +0000, Roman Rokytskyy wrote:

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




Regards,

Ann
www.ibphoenix.com
We have answers.