> Hi Svein,
>
> Wow, this sounds pretty serious. We use the Firebird ODBC driver, and
> I checked our connection attributes... and I found
>
> SQL_ATTR_AUTOCOMMIT=1
>
> I'm guessing this means the ODBC driver is doing a "soft commit"? I'll
> have to peek at the source :)
>
> Thanks again!
>
> David

this means that with the issue of any single statement not specifically
wrapped in start/end transaction statements, that single statment will be
hard committed as soon as it executes. It does not mean that it is soft
commited.
Alan

>
> --- In firebird-support@yahoogroups.com, Svein Erling Tysvær
> <svein.erling.tysvaer@k...> wrote:
>
>
> > [...] autocommit
> > is a problem (speedwise, the result is identical to a long-running
> > transaction). It does ensure that data won't be rolled back, but it
> > doesn't allow the oldest active transaction to move forward. The
> > result is that your database grows because it has to store every
> > version of every record. If you have a small database with few
> > updates, then you're fine, otherwise your queries gradually become
> > slower until your database becomes useless.
>