Hi guys, maybe i have always misunderstood the garbage collection mechanism, the sweep interval, etc.. and i'm realising only now, but:
I have this database (Firebird 3.03 SuperServer x64) Gstat execution time Thu Feb 15 05:00:01 2018 Database header page information: Flags 0 Generation 486 System Change Number 0 Page size 4096 ODS version 12.0 Oldest transaction 356 Oldest active 357 Oldest snapshot 357 Next transaction 471 Sequence number 0 Next attachment ID 58 Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC Shadow count 0 Page buffers 0 Next header page 0 Database dialect 3 Creation date Feb 14, 2018 22:50:34 Attributes force write Variable header data: Sweep interval: 0 *END* In this db i have 2/3 tables with this situation Average record length: 342.71, total records: 57221 Average version length: 12.05, total versions: 272433, max versions: 23 Average fragment length: 27.78, total fragments: 15232, max fragments: 1 Average unpacked length: 1331.00, compression ratio: 3.88 Average record length: 107.21, total records: 279298 Average version length: 9.06, total versions: 348294, max versions: 6 Average fragment length: 7.71, total fragments: 39741, max fragments: 1 Average unpacked length: 247.00, compression ratio: 2.30 My question is : why garbage collection mechanism starts automatically when i browse these tables, despite the fact that i have Sweep Interval = 0 ? What is the point that i'm missing ? Thanks, ciao ! Arnaldo