Hello David

It will nice if you can enhance the autocommit mode. I don't know exactly which way are you thinking about, but let me explain
an idea I have about a solution.

The time to execute an statement in autocommit mode will decrease if the number of messages for each statement executed is
reduced. Now there is 3 messages for each statement executed "create transaction, execute, commit".

It seems that using commit_retaining it is possible to use only 2 messages "execute,commit_retaining" for each statement
executed, because in Autocommit mode there is only one transaction that starts and commits repeatedly. If the commit transaction use
commit_retaining and the start transaction only reuse the transaction without creating a new one, then the performance problem can
be solved. Perhaps an different LocalTransaction can do that.

I hope this idea helps to find a solution.

Regards
Blas Rodriguez Somoza

----- Original Message -----
From: "David Jencks" <davidjencks@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Monday, June 24, 2002 9:10 PM
Subject: Re: [Firebird-Java] Driver status


> Wow!!!
>
> Thanks!!!!
>
> I'd like to also take a look at the autocommit again and see how hard it
> would be to solve using multiple concurrent transactions. It might not be
> as hard as I thought at first.
>
> david jencks
>
> On 2002.06.24 14:54:34 -0400 Blas Rodriguez Somoza 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:
> > Firebird-Java-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
> >
> >
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>