Here is the header data. Remember I had to revert back to 1.5.3...

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
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
*END*



----- Original Message ----
From: Gary Benade <gary@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, December 12, 2006 11:59:07 PM
Subject: Re: [firebird-support] Re: Update: CPU Pegged on Firebird v2

>Yes, I've considered it, but I know this is not the case. Subsequent
>threads running the same query post their data just fine. Even though
>it is slow, because a previous thread has caused the deadlock problem

Sorry to keep hammering on about this, but that sounds like garbage collection. The thread that triggers the GC process is kept busy and will not return results until the process is done, any subsequent threads will run just fine, although obviously slower due to the server workload of the GC thread.
Could you let us know what your sweep interval is set to and post your header page stats.

Regards
Gary

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




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