Subject Re: Driver too slow
Author rrokytskyy
> I've also found that database access in my application with the
> binary release of the class 4 driver that was posted on this group
> is approximatly 5 times slower the IC2.01 in their areas where the
> database access times are logged.
>
> This is with a local database on Win2000 using Firebird 1. It seems
> to me that in theory the class 4 driver should be able to
> outperform interclient on a local connection as it bypasses
> Interserver( another loopback connection, protocol, ect ) and
> issues (I assume) the same requests as Interserver would do but
> directly to the database engine.

No, type 4 driver will never outperform the InterClient simply
because the network traffic is higher. Also, add some time to prepare
all data for API calls, that are done in InterServer on native level,
and you will understand that type 4 cannot be faster than IC.

Problems with IC are:

1) it is not under development, so you have a 2-year old code (IC 2.5
cannot be taken into account, because you have to buy IB 6.5)

2) you have only 3 deployment platforms for InterServer (Windows,
Linux and Solaris), and InterServer has to run on the same host as
database does.

But type 4 driver should not be so slow. Or, more correctly, it
should be as fast as InterClient if the amount of data transferred
over the wire is much more bigger than request data.

Best regards,
Roman Rokytskyy