|Subject||Re: [firebird-support] Re: Update: CPU Pegged on Firebird v2|
>Yes, I've considered it, but I know this is not the case. SubsequentSorry 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.
>threads running the same query post their data just fine. Even though
>it is slow, because a previous thread has caused the deadlock problem
Could you let us know what your sweep interval is set to and post your header page stats.
[Non-text portions of this message have been removed]