Subject Re: firebirdsql vs interclient speed
Author llafranc78
Hi Herbert

I've got a 100Mb lan, with Win2000 Pro.

Yes, firebirdsql is slower for queries, but I still think that 35 secs
is to much for interclient, even if you lan is not a 100Mbit.
I've just read one of your previous posts, when you said you're using
"Firebird 09 something". Try installing FirebirdRC2 and see what
happens: maybe the problem is the server, not the client :)

As for the inserts, I've checked them once again. You're right, 20ms
is utopia :) I don't know what I was looking at. I've tried an insert
(over the network) three times using firebirdsql, with following
results: 631 ms, 547 ms, 491 ms.

Ciao
Luca





--- In IB-Java@y..., Herbert.Augustiny@s... wrote:
>
> Hi Luca
>
> The times I was talking about are from a select, I never finished a
insert
> of a big file with firebirdsql.
>
> Your select speed is about 5 times slower with firebirdsql than with
> interclient and from what I see it seems to get worse if you have less
> bandwith + routers!!
>
> If the time of 20 ms for an 8.5MB file insert is true, you must have at
> least GBit Ethernet in your lan connection. If I calculate the wire
> throughput (without overhead) I get 350 MBits/sec ??
>
> What kind of network do you have?
>
> Herbert
>
>
>