Subject Re: [firebird-support] Garbage collection performance issues ????
Author Robert martin
Wow. Thanks for your extensive reply.

My code if very transaction centric in this particular app. All
transactions are manual and as short as possible so I hadn't really
considered that to be the issue. I have just checked the database which
has been running for the last couple of days and get the following...

Database header page information:
Flags 0
Checksum 12345
Generation 895815
Page size 8192
ODS version 11.2
Oldest transaction 846877
Oldest active 846878
Oldest snapshot 846878
Next transaction 846888
Bumped transaction 1
Sequence number 0
Next attachment ID 48916
Implementation ID 16
Shadow count 0
Page buffers 200
Next header page 0
Database dialect 3
Creation date Mar 21, 2012 15:00:43
Attributes force write

Variable header data:
Sweep interval: 0

This looks pretty good to me, although I am far from expert!

Note that sweep is now 0. I have a scheduled sweeps at 1am. My
database seems to be running ok at this point.

I expect that at times the gap between transactions is quite large as
the system periodically starts a write transaction that is open while
the system pumps data from another database into this one. This might
run for some minutes, most other transactions are however read
transactions and would not be acting upon this data.

I really appreciate your email but I don't think it is transactions in
this case.

p.s. sorry about posting this as a new email, for some reason I can post
new emails but all my replies bounce back.