Subject Re: Update: CPU Pegged on Firebird v2
Author Adam
--- In, "Fabian Chocron"
<fabianch@...> wrote:
> I wonder why I have a CPU 100% constantly?

Asides from your ping pong SMP issue, perhaps also you have a rogue
query that Firebird 2 is attempting to use a dumb plan for? The
optimiser has been changed, mostly for the better but there is
obviously the potential for some queries to perform worse. There is
also a change to index use with respect to 'not in' queries due to the
possibility of inconsistent data when using the index, and this may be
affecting it.