Hi group.

I've working around tuning up a database speed and found that gstat -h shows valuable information about transactions. Also that gfix -sweep removes garbage from the database.

I understood that when Next transaction grows too much from Oldest active transaction, "sweeping" the database makes this difference become smaller.

But this is not the case with my database.

What am I doing wrong?

this is the gstat -h from the database:

*************************************************

Database "d:\med6\ibdata\sistmed6.fdb"

Gstat execution time Mon Jul 01 10:39:55 2019

Database header page information:

        Flags                   0

        Checksum                12345

        Generation              236628301

        Page size               4096

        ODS version             11.2

        Oldest transaction      236413964

        Oldest active           236413965

        Oldest snapshot         236413965

        Next transaction        236627938

        Bumped transaction      1

        Sequence number         0

        Next attachment ID      31194

        Implementation ID       16

        Shadow count            0

        Page buffers            0

        Next header page        0

        Database dialect        3

        Creation date           Mar 24, 2018 10:27:14

        Attributes              force write

    Variable header data:

        Sweep interval:         20000

        *END*

*************************************************

Any help will be appreciated.

Regards,

Hernando.