Sean,

This is the header from my 1.5.3 database which I am accessing from a 1.5.3 server. I had to rollback to this version because 2.0 was jacked. Currently, this database is in production mode and running perfectly and is responding to requests lickety split. Attached header from right now:

Database header page information:
Flags 0
Checksum 12345
Generation 358867
Page size 4096
ODS version 10.1
Oldest transaction 452
Oldest active 453
Oldest snapshot 453
Next transaction 358860
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Dec 11, 2006 12:29:47
Attributes no reserve

Variable header data:
Sweep interval: 0


----- Original Message ----
From: "Leyne, Sean" <Sean@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, December 13, 2006 11:45:35 AM
Subject: RE: [firebird-support] Re: Update: CPU Pegged on Firebird v2

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

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

Sean




[Non-text portions of this message have been removed]