NOTE: I've posted this question into "Firebird-general", but now I realize that that group seems not to be active nowdays, so I post it here. 

---

Hello! I'm noticing a small increase of my database size. Now it has 566,992 KB. After a backup/restore the size goes to 533,640 KB. I don't have long running read/write transactions (well... I think)

The headder of my database shows me this. I think I read somewhere that the ideal is always to have the "Oldest active" transaction equal to the "Oldest snapshot"... is that so? In any case, what means the difference I'm having?

thanks!!

Database "datos.fdb"

Database header page information:

Flags 0

Checksum 12345

Generation 1145236

Page size 4096

ODS version 11.2

Oldest transaction 1145222

Oldest active 1145223

Oldest snapshot 1144871

Next transaction 1145228

Bumped transaction 1

Sequence number 0

Next attachment ID 784

Implementation ID 26

Shadow count 0

Page buffers 0

Next header page 0

Database dialect 3

Creation date Sep 6, 2017 19:13:38

Attributes force write

    Variable header data:

Sweep interval: 20000

*END*