Many thanks, Dmitry, that resulted in a considerable reduction in
network traffic and put Firebird well ahead of MySQL in my database
server grand prix :).

Regards,

Robert.

Dmitry Yemanov wrote:

> Robert wrote:
>
>> I'm using Firebird 2.0.3.12981 on Suse Linux 9.0, and the IBPhoenix ODBC
>> driver 2.0.0 on Windows clients. I've been using Wireshark to monitor
>> network traffic to look for inefficiencies. A particular series of
>> transactions generates over 11,000 packets and over 6.5 megabytes of
>> data. The same series of transactions using MySQL generates just 725
>> packets and 121 kilobytes of network traffic, and goes significantly
>> faster. Much of the 6.5Mb of data sent using Firebird turned out to be
>> long streams of zeros. Wireshark labels these packets as Protocol "IB"
>> (ie Interbase), Info "Reply void". Can anyone tell me please what's
>> happening here? How do I stop this behaviour?
>
> Consider testing FB v2.1. The network protocol is optimized there.
>
>
> Dmitry
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>

--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 269.24.0/1459 - Release Date: 5/21/2008 17:34