Subject RE: [firebird-support] updates getting slower and slower
Author Helen Borrie
At 08:17 AM 25/10/2004 -0400, you wrote:

>:: Do you have a read transaction opened?
>What exactly is a read transaction?

It's a transaction in which you are reading stuff, i.e. one that includes a
SELECT statement. If you have a read-write transaction containing a SELECT
statement that never gets committed, or keeps getting committed with RETAIN
(CommitRetaining, the default in all Borland dataset interfaces) you
prevent garbage collection from happening to the records you selected and
you build up monumental transaction accounting structures in RAM.