Subject Re: [ib-support] Network performance
Author Helen Borrie
At 03:10 PM 12-12-01 +1000, you wrote:
>We're trying out Firebird with Dephi 6 interbase componencts because MS Access
>(with ADO components) is running slow. It was great when the gdb file was on the
>development machine. Firebird was running identical queries (SELECT * FROM
>tablename ORDER BY field) on identical data between 2 and times faster. But
>when we put the GDB file on another machine and started connecting to it over
>the network the Access run was faster, sometimes twice as fast.
>We're very new to this. Are there any tweaks to make in Firebird to speed up its
>network performace?

If local was fast then network should be faster - as long as it's TCP/IP you're using and not NetBeui (windows networking).

But provide some details: Hardware & OS environment, SQL statement, index details, connection string used, etc.

It would also be pertinent to know what network protocols are running on your network and which ones are enabled in the client's protocol stack...