On 03-04-2002, Herbert.Augustiny@... wrote:

> I think the problem gets even worse if there is a slow network connection
> like a dialup or internet connection.

You are right. The native Firebird network protocol is not as optimized
as the interclient-interserver protocol. So, performance over slow links
is (and will be) worse with the type 4 driver than with interclient.
But we can't do anything about that, because we can't change the native
protocol now.

On the other side, if you use the driver over a LAN it should be as fast
as interclient perhaps more (the benchmarks that I ran during the
optimization phase of the JGDS show that). But, the performance of the
type 4 driver depends heavily on the max buffer size used in JGDS, and
the optimal max buffer size depends on the size of the statements that
you execute. So, it is impossible to set an optimal max buffer size.
Perhaps, it should be a configurable parameter through an external
property.

Bye.

--

+--------------------------+
| Alejandro Alberola Arias |
| Boix i Oltra, S.L. |
| email: alberola@... |
+--------------------------+