Devart Forums

Posted: **Wed 02 May 2012 09:33**

Hello,

I use IBDAC V3.60.0.24 with AutoCommit=False and FB V1.5.
When I look into the Database header page information I see the following:

Code: Select all

        Flags                   0 
        Checksum                12345 
        Generation              304117 
        Page size               4096 
        ODS version             10.1 
        Oldest transaction      27528 
        Oldest active           27529 
        Oldest snapshot         27514 
        Next transaction        304108

What could be the reason for the big gap between NT and (OT/OA/OS) and waht ca I do to solve the problem? Currently I have no performance issues. Everything works fine.
Thanks,

Michael

Posted: **Thu 03 May 2012 12:23**

Hello.

Such problem can occur when TIBCTransaction.CommitRetaining method is executed. Try to avoid using CommitRetaining and use Commit instead of it.
To solve the problem you can try to backup and restore your database.
You can find more information about NT, OT, OA and OS parameters in the official Firebird documentation here: http://www.firebirdsql.org/manual/bk02ar17s03.html

Devart Forums

Big difference to Next Transaction

Big difference to Next Transaction

Re: Big difference to Next Transaction