Subject RE: [firebird-support] Re: Improve read speed on a database intensively written
Author Leyne, Sean

> Hi Alex, this is the header info. do you need more?
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 22515374
> Page size 16384
> ODS version 10.1
> Oldest transaction 22488749
> Oldest active 22488750
> Oldest snapshot 22488615
> Next transaction 22515366

The difference between the Oldest Active and Next Transaction values
show that you have an application/connection which is maintaining an
active transaction. This transaction is causing the system to perform
extra work (likely disk activity), thus slowing down the system

> Variable header data:
> Sweep interval: 20000
> *END*

You should set you sweep interval to 0 and then create an OS scheduled
task to perform a database sweep during an appropriate low activity
window (late night).

This change will prevent transactions from 'freezing' while the engine
performs the sweep, which can be a very time consuming operation.