I think for inserts and updates you are right.
But why should i use explicit commit for queries ?
I always use autocommit mode when I'm only reading values from the db.

gruß
Carsten

----- Original Message -----
From: "David Jencks" <davidjencks@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Wednesday, October 16, 2002 6:17 PM
Subject: Re: [Firebird-Java] Driver Speed Tests


> IMO our driver should be faster and have lower latency.
>
> I haven't looked at why we are slower yet. My first guess is that we spend
> a lot of time dealing with autocommit. This test appears to use
> autocommit. For each operation that contacts the database, we are making
> at least 3 calls: start tx, do work, commit tx.
>
> There may be a firebird native autocommit setting I haven't found which
> would reduce this to one call.
>
> In any case (IMO) autocommit is not used in real work and we should run the
> tests with larger amounts of work/transaction and explicit transaction
> control.
>
> thanks
> david jencks
>