Hi,
So what is your advice when reading data regarding performance?
Should I use autocommit yes or no?
And if no, if I use a connection for reading only, should I commit or
rollback when returning the connection?
Or rollback and commit is not necessary when a connection is used for
reading only (when no locking is used => for update close)?

Thank you for your advice.
Frederic

--- In Firebird-Java@y..., "Blas Rodriguez Somoza" <blas@p...> wrote:
> In the June tests, the selects in autocommit mode employ the same
time in
> Jaybird and in Interclient.
>
> ----- Original Message -----
> From: "Carsten Schäfer" <ca_schaefer@g...>
> To: <Firebird-Java@y...>
> Sent: Wednesday, October 16, 2002 6:32 PM
> Subject: Re: [Firebird-Java] Driver Speed Tests
>
>
> 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@d...>
> To: <Firebird-Java@y...>
> 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
> >
>
>
>
> To unsubscribe from this group, send an email to:
> Firebird-Java-unsubscribe@y...
>
>
>
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/