Subject Re: Firebird v2 CPU Pegged
Author slalom91
--- In, Helen Borrie <helebor@...>
> At 07:34 PM 12/12/2006, you wrote:
> >You may want to try changing the garbage collection policy to
> >'cooperative' in firebird.conf and see if that makes a difference,
> >that's how 1.5 used to do things.
> Err..not quite. Superserver 1.5 didn't do cooperative GC; the new
> settings allow it as an option or in combination with the
> GC that v.1.0 and 1.5 Superserver use. (The policy setting doesn't
> apply to Classic: it can only do cooperative).
> V.2.0 defaults to the combined policy. It would be worthwhile
> one or the other on its own to see whether there's an
> improvement. But, to be clear, background, not cooperative, gets
> back to the 1.5 Superserver policy.
> >Don't forget to restart the server process.
> Amen. :-)
> ./heLen
I did try manipulating this setting to each of the allowed values and
it did not work. After reading Dennis's post titled "Issue: deadlock
with Firebird and Delphi. ref/eDN7002040583", I am sure we are
experiencing the same problem.