Subject Re: [ib-support] Re: Problem with growing database
Author Helen Borrie
At 08:00 AM 10-12-02 +0000, you wrote:
>Hi and thanks every one. I think this kind of support is the best.
>The growing database was (of cause) due to my lack of skill in DB-
>programming. I did COMMIT RETAINING instead of COMMIT. But from what
>I understand this only stores some kind of Save Point and it does
>not a real COMMIT.

It's not a Savepoint (although Savepoints *are* coming in Fb 2). It is a
full (irreversible) Commit but, instead of closing the cursors associated
with the transaction, it keeps them open for the new transaction. Hence,
everything to do with the original transaction and each new one that is
started after Commit with Retain, using the same cursors, remains
interesting and therefore unavailable for garbage collection.