| Subject | Re: Update: CPU Pegged on Firebird v2 |
|---|---|
| Author | Adam |
| Post date | 2006-12-13T22:36:39Z |
--- In firebird-support@yahoogroups.com, "Fabian Chocron"
<fabianch@...> wrote:
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.
Adam
<fabianch@...> wrote:
>Asides from your ping pong SMP issue, perhaps also you have a rogue
> I wonder why I have a CPU 100% constantly?
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.
Adam