Subject RE: [firebird-support] Re: Update: CPU Pegged on Firebird v2
Author Leyne, Sean
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 347204
> Page size 4096
> ODS version 10.1
> Oldest transaction 452
> Oldest active 453
> Oldest snapshot 453
> Next transaction 347197

There's your problem!!!!

You have a connection which has an open/uncommitted transaction!!!

This means that every select is having to 'reconcile' all of the
accumulated record changes for each record in the database -- no wonder
you're running slow, you have over 3460,000 transactions of data to

Additionally, you are accessing a v1.x database (ODS 10.1) with v2.0.
Although supported, you would see the maximum benefit of the
optimizer/indexing changes if you backed up and restored the database
(to ODS 11).