Hi,
we have switched our aplication from Firebird 1.0 and Interclient to
Firebird 1.5 with Jaybird1.5RC3 (type 4 mode).
I 've done some tests on my Windows XP workstation and perfomance was the
same or better than before.
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.
On some other system (XEON System, maybe with Hyperthreading) i see 100%
utilization at the beginning
and when it comes to our biggest table it goes down to 0-10 % and so it
takes very long to complete the reads on this table.
With our old version there was no such problems.
I have tested Firebird 1.0 and Firebird 1.5.1RC3 on the Pentium III-S
machine without any difference.
Same databases on my system works normal with 100% cpu-utilization.

Does anyone have an explanation for this behaviour ?

mfg
Carsten