Subject Re: [ib-support] CPU 100% over NT
Author Helen Borrie
At 09:28 PM 02-08-02 +0000, you wrote:
>Hi to all,
>My friend ask me something that really I don't know what to tell him (I very
>new with InterBase)... maybe you can help me:
>I have installed Interbase 6.0 OpenSource on Win NT 4.0.
>When I do any kind of query the CPU usage go to 100%, and all system
>go very slowly until the query end.
>I attempted to optimize all my queries but that only reduce the elapse time
>of that queries
>Mi question is:
>is there any way to distribute more efficiently the CPU usage with all the
>connected users?

If the server is on a SMP machine, make sure the CPU affinity is set to a
single processor. Windows doesn't behave well with InterBase/Firebird when
there are multiple processors...

You might also need to experiment with reconfiguring the database cache
using the gfix utility - see the Operations Guide for instructions.

Apart from that, you should post an example of a query that causes this
behaviour...and also describe what kind of application interface you are
using where this behaviour occurs.


All for Open and Open for All
Firebird Open SQL Database · ·