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

--- 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.