Subject Re: [firebird-support] Firebird 1.03 and PIV 3Ghz
Author Patrick Pellizzari


----- Original Message -----
From: Helen Borrie
Sent: Friday, August 01, 2003 11:00 AM
Subject: Re: [firebird-support] Firebird 1.03 and PIV 3Ghz

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...


Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]