Roman Rokytskyy wrote:

> Hi,
>
>> At some custumer sites we now have problems with cpu-utilization.
>> It's to low !
>> They are all Windows 2000 Server machines
>> When we start our application (many selects on many tables) on one
>> system we have an average utilization of 25-30 %
>> (Dual Pentium III-S system) instead of 100 %, so it takes 3 times
>> longer than normal.
>
> What happens to the disk system?

Nothing special, what do you mean ?

>
>> I have tested Firebird 1.0 and Firebird 1.5.1RC3 on the Pentium
>> III-S machine without any difference.
>
> You mean that also there CPU is at 20-30% of load?
>
>> Same databases on my system works normal with 100% cpu-utilization.
>>
>> Does anyone have an explanation for this behaviour ?

I ' ve done some more testing (not with a profiler yet) on the Dual Pentium
III-S System.
There seems to be a problem with autocommit = true mode.
I've done all my only reading transaction in this mode,
there were never these problems with interclient and there are no big
problems with Jaybird on a single processor system.
But on dual system i have this cpu utilization-problem.
Now i switched to autocommit = false and behavior is much better.
Not 100 % cpu utilization but about 80 % which makes it much faster.
Maybe you could take a look in autocommit code ?

Carsten