Hi,

> We've been using Interclient with Coldfusion MX for a few months
> now and we've been using JayBird on our test server for a couple of
> weeks. We're seeing *much* better performance with JayBird (up to
> twenty times quicker on some queries) and not having to run
> Interserver on the server makes me much happier.

This is quite easy to explain - InterClient is not multithreaded.
That means that all requests are executed one by one. So, if you have
concurrent users, InterServer synchronizes their requests internally.
In case of JayBird each connection has its own thread on the server.
But on Linux when using inetd services (classic server) each
connection has its own process, and InterClient performance should be
same or better than JayBird.

> However, I'm still unclear as to the release status of JayBird.
> Should we put in on the production server ?

We are pretty close to RC2. I have only one issue in my todo list -
correct handling of longvarchar conversions (BLOB SUB_TYPE 1). List
of open bugs you can check on SF.net (there is one serious bug when
exception happens in commit() or rollback(), others are not so
critical).

My personal opinion is that JayBird is not worser than InterClient
2.01. InterClient 2.01 has bugs and I do not know anybody willing to
fix them in Firebird CVS tree. However I haven't tried InterClient
2.5 (shipped with IB 6.5), maybe it has better quality than JayBird.

Best regards,
Roman Rokytskyy