Subject Re: [Firebird-Java] Re: Driver status
Author Blas Rodriguez Somoza
Hello Roman

Until now we don't test PostgreSQL but compared with other databases/drivers, the only problem with FB is in the selects, FB
takes too much time.

For instance FB outperforms SAPBD on inserts and mixed tests, but takes 180% the time of SAPDB in the selects. I don't know if
the problem is in the database kernel or in the communication layer, but this is perhaps the next thing to review. I don't think it
is in the driver because the problem exist with FB Driver and with Interclient.

I have not too much time now to do the test with IC 2.5, but I expect jDataMaster will be available for download this week,
including the test suite.

I'll be very pleased if you can use jDataMaster, we also need testers. I'll notify you as soon as we put it in the net.

Blas Rodriguez Somoza.

----- Original Message -----
From: "rrokytskyy" <rrokytskyy@...>
To: <>
Sent: Monday, June 24, 2002 10:07 PM
Subject: [Firebird-Java] Re: Driver status

> Blas,
> Great news! My colegues say that Firebird with our driver is faster
> than PostgreSQL with its driver, but I didn't expect that we can
> outperform InterClient! :) Thanks a lot for such great news!
> Can you perform similar testing with InterClient 2.5? It is part of
> InterBase 6.5 distribution that is available for evaluation download
> from Borland site? This can be also useful for IB Phoenix people in
> promoting Firebird project.
> BTW, is jDatamaster available for evaluation? If yes, is your test
> suite available? I can try to make this by myself.
> Thanks,
> Roman
> P.S. Beware of IB 6.5, I suspect that you can have either IB or FB on
> machine. :)
> --- In Firebird-Java@y..., "Blas Rodriguez Somoza" <blas@p...> wrote:
> > Hello
> >
> > I was working on compliance and performance the last two months,
> I think now the work is finished with the exception of a
> > performance issue in autocommit mode.
> >
> > I evaluate the driver compliance and performance with
> jDatamaster and the results are the following:
> >
> > 1.- The driver comply with JDBC except three non implemented
> methods. Interclient 2.01 fails in 161 tests.
> > 2.- The Driver performs better than Interclient excluding
> inserts with autocommit. The difference is greater on remote
> > connections.
> >
> > Until now the message about JCA-JDBC Driver is that it does
> implement JDBC less than Interclient, and that it performs worse the
> > Interclient. Now we can say that JCA-JDBC implement JDBC much better
> than Interclient does and that excluding autocommit, the Driver
> > performs better than Interclient.
> >
> > I have commited some changes to JDBC20_compliance.html, the
> performance tests are now included in the document.
> >
> > The only thing to be enhanced until version 1.0 is the
> performance in autocommit mode. Perhaps we reuse Fb transactions using
> > commit_retaining. It will be great if the driver performs better
> than Interclient also in Autocommit mode.
> >
> > Regards
> > Blas Rodriguez Somoza.
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to