Subject | RE: [firebird-support] updates getting slower and slower |
---|---|
Author | Helen Borrie |
Post date | 2004-10-25T13:25:18Z |
At 08:17 AM 25/10/2004 -0400, you wrote:
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.
./heLen
>:: Do you have a read transaction opened?It's a transaction in which you are reading stuff, i.e. one that includes a
>
>What exactly is a read transaction?
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.
./heLen