Hi Simon,

Short answer: Yes.

Longer answer: I think RC1a is better than Interbase. RC2 will be out
soon.

If you can't wait for RC2, I would try out the CVS build with your app and
use it if it runs OK. It has fixed a lot of bugs but many are only found in
more high end stuff when using it with a J2EE server.

The only danger with the CVS build is that mods or additions occasionally
break stuff that was working before. But somebody usually squawks within
hous if that is the case.

To test it out wit your apps do the standard inserts, updates, and deletes
and use a tol to check out the database manually to be sure all is OK.

Pay particular attention to dates and times, number conversions, blob data,
and character sets.

I'm not sure what your environment is with ColdFusion (thousands of users?,
e-commerce site that will cost your clients lots of money if there is a
problem?, yada yada) but we've been running it with Tomcat on Solaris in a
small company and JayBird is very solid. Much more so than Tomcat.

Firebird never crashes. With Interclient the web apps would occasionally
get non-responsive and I'd have to restart Tomcat. I see much less of that
with JayBird, and the stand alone apps that I have running JayBird have run
flawlessly with the same databases, so I'm certain Tomcat is the culprit in
any instability.

To test that I ran Tomcat without making any database calls in the web apps
and had the same instability, so while not absolute proof I'm convinced that
JayBird is very stable.

I don't have high loads so I can't tell you how JayBird would behave under
stress, but from what I've seen in a servlet container environment the JDBC
driver accounts for very little overhead. The performance of the app server
and the database itself are far more of a factor.

I'm a little surprised about your experience with the high speed of JayBird.
Your particular apps must really give Interclient fits. Not to belittle
JayBird but most people have not seen huge boots in performance with
JayBird.

Do you think this will be true with the higher loads on your production
server? It may be that Interserver becomes a bottleneck under certain
circumstances.

Rick

----- Original Message -----

> Please excuse the rather naive question but...
>
> 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.
>
> However, I'm still unclear as to the release status of JayBird. Should we
put in on the production server ?
>
> Any thoughts would be very welcome.
>
> Thanks,
>
> Simon.