--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:

>
> 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
> operation.
>

This database is being injected by a scalability test program (250
clients). Maybe it's caused by it?
I have a library of APIs handling all FB read/write. For every
read/write I always open-do the job-close the connection.

>
> > 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.
>
>

Cool, I will do it.