Re: [firebird-support] Firebird's default settings

2012-07-17 Thread Thomas Steinmaurer
>> The problem is that SuperServer is multi-threaded but not >> interlocked, so only one thread runs at a time so it cannot take >> advantage of multiple cores. Some operating systems move the process >> from one core to another in an attempt to balance load. That degrades >> performance, but can b

Re: [firebird-support] Firebird's default settings

2012-07-16 Thread Josef Kokeš
> The problem is that SuperServer is multi-threaded but not > interlocked, so only one thread runs at a time so it cannot take > advantage of multiple cores. Some operating systems move the process > from one core to another in an attempt to balance load. That degrades > performance, but can be pre

Re: [firebird-support] Firebird's default settings

2012-07-16 Thread Ann Harrison
On Mon, Jul 16, 2012 at 4:46 AM, Josef Kokeš wrote: > Hi! > > Specifically, assuming Firebird > 2.5 in the default install (which, I believe, is using SuperServer): > > - CpuAffinityMask - I can see why the value 1 would be a safe lower > bound, but why doesn't the server default to a value w

[firebird-support] Firebird's default settings

2012-07-16 Thread Josef Kokeš
Hi! I have never tried to change Firebird's default settings, because the server has always been "good enough" and "if it isn't broken, don't fix it". But I can't help but wonder about some of the settings, because I don't understand their default values. Specifically, assuming Firebird 2.5 in