>No, type 4 driver will never outperform the InterClient simply
>because the network traffic is higher.

I specificaly stated 'class 4 driver should be able to
outperform interclient on a ''local connection''' Meaning with the server
and client on the same machine with no 'real' network involved.

I reliase that their may be more data going through the loopback connection
between the Type 4 driver and interbase then there would be between
interserver and the interbase but surely this is offset by the fact that the
connection between interclient and interserver is eliminated. I mean with
Interclient all data goes first to interserver though one loopback
connection and then on to interbase through another loopback connection.

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

I dont belive that well written Java code is significatly slower then native
code on modern virtual machines, you would expect to at least get within
half the speed of native code, but surely even this is insignificant
compared to the time required for the database to actually process the
request(surely just reading a single non sequentiual DWORD from the disk
dwalfs this) and so should not make a percievable difference.

These are my opinions and if you belive they are wrong I would like to hear
why.

Thanks

Ryan

-----Original Message-----
From: rrokytskyy [mailto:rrokytskyy@...]
Sent: 15 April 2002 11:57
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Driver too slow

> 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



To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/