Subject | Re: [ib-support] Re: Interbase/Firebird memory question |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2003-02-27T10:58:07Z |
That depends on how much each transaction does, IB/Fb will have to keep old
versions for everything that has been inserted/updated/deleted by all
transactions started after the OAT.
Set
At 10:18 27.02.2003 +0000, you wrote:
versions for everything that has been inserted/updated/deleted by all
transactions started after the OAT.
Set
At 10:18 27.02.2003 +0000, you wrote:
>Hi Svein,
>how big is 'big'?
>Thx
>
> > I cannot help you with your calculations, but would recommend you to start
> > by checking the Oldest Active Transaction (OAT) and the Next Transaction.
> > If the gap between these two numbers is big, you have a problem with an
> > uncommitted transaction (and uncommitted transactions means that the
> > database may have to store lots of old versions of records).