Subject Re: [firebird-support] Firebird 1.03 and PIV 3Ghz
Author Helen Borrie
At 10:30 AM 1/08/2003 +0200, you wrote:
>I have just installed my new PIV 3.0Ghz.
>The new technology of the PIV 3Ghz makes it possible to see this PIV like
>2 procs (like Xeon)...
>With Firebird 1.03, considering which it has a parameter which makes it
>possible to tell it on which proc it must work, I make some tests.....
>Result of the tests:
>On a request which take 2,8S on the PIV 3Ghz :
>On a PIV 2.5 Ghz
>1 user = 3,079s
>3 users = 5,578s 5,172s 5,953s
>On a PIV 3.0Gh without modifying the IB config
>1 user = 2,813s
>3 users = 3,313s 3,609s 5,062s
>On a PIV 3.0Gh with CPU_AFFINITY 3
>1 user = 2,859s
>3 users = 3,187s 5,359s 5,703s
>I launched the Taskmanager which shows me well that in the first case
>alone 1 proc works, and in the 2nd case, both works....
>Is what somebody has an idea of why it's not faster when using 2 procs ?

Unfortunately, on Windows the Superserver can't use multiple procs without
getting the see-saw effect - which slows your server down to a crawl. If
your BIOS supports HT, you need to disable it.

This is a Windows deficiency with the Superserver process architecture, for
which there's no workaround yet. Just one more thing to love about Windows
as a platform for database servers...