Subject Re[3]: [firebird-support] Firebird performance on Dual Core machine
Author Andi Wangsadijaya
Hello Helen,

On Monday, January 2, 2006, 7:02:57, You wrote:

> At 06:44 AM 2/01/2006 +0700, you wrote:
>>Hello Helen,
>>
>>On Monday, January 2, 2006, 5:53:18, You wrote:
>>
>> > Yes, it's true for the Superserver version, but not for Classic.
>>
>> > With SS you should keep the CPU affinity to one CPU. By default, the value
>> > (a bitmask) is 1, which sets the affinity to CPU 0. Read the release notes
>> > and the notes in Firebird.conf. The release notes provide the algorithm
>> > for calculating the CPU affinity bitmask.
>>
>> > ./heLen
>>
>>If I set the affinity to CPU 0, will the performance to drop? Or it
>>just make the performance is better than set the affinity to CPU more
>>then 0?

> No. As I already told you, the affinity is set by default to CPU 0. You
> should not try to change it, unless for some reason you want to set it to
> CPU 1 instead.

> There should be no performance difference between CPU 0 and CPU 1.

> Performance will die if you change the affinity mask to two CPUs.

> ./heLen

You told that the performance of firebird superserver version will be
drop on SMP Machine (including dual core and hyperthreading). At the
other side, you told that performance will die if I change the affinity
mask to two CPUs. Is that meaning if I leave the default value
(CPUAffinityMask = 1 or 2) the performance won't be drop? I'm already
read the manual, but I can find the answer of my question above.


--
Best regards,
Andi Wangsadijaya

Send instant messages to your online friends http://asia.messenger.yahoo.com