Subject Re: [Firebird-Java] Tunning remote Jaybird connections
Author Roman Rokytskyy
> I was curious if there were any tunable parameters I should start with
> to see if I can expedite things at all. I am not dealing with any blob
> data. I am not sure if the socketBufferSize would make a difference or
> not?

I think noone will tell you exactly. From my experience, Windows boxes do
not need it, but I have also seen some Linux boxes where it increased the
speed 10x (actually those boxes were the reason for introducing this
parameter).

> Speed is the same on Linux and Windows clients. Server is Linux, FB SS
> 1.5.3, JayBird 2.1.0 beta1.

Then I guess there will be no difference, but you can try.

> I was considering using Zebedee, but I don't really think it's a problem
> compression could solve. Possibly, but seems the delay is mostly in
> passing the query to the db, and waiting for a resultset. Emtpy ones
> seem to take as long as ones with data. So it does not appear to be data
> size or etc related.

You can try Ethereal to check the network packets that are traveling between
your machines...

Roman