Użytkownik Helen Borrie <helebor@...> napisał:

>configuration file. One parameter you should take an interest in is
>CpuAffinityMask.

You can use it only on Windows...

>
>Stay with the default settings for this server, which allocate 75 Kb pages
>(static DbCache) per connection. With a 4Kb page size, this allocates
>about 300 Kb database page cache to each connection. 512MB of RAM isn\'t
>much to offer to 20 concurrent users and two CPUs if you set the cache too
>high. 20 users will eat ~6 Mb of RAM with a 4 KB page

Exactly! So the server will use only 6MB for cache for all 20 users. Don't you think it's too small?

>
>>Server is running on 2.4 SMP kernel - i\'ve heard that 2.6 kernel is better
>>for Firebird CS running on 2CPU (or 2Intel HT CPUs which in fact gives
>>4CPUs). Is that true ?

I remember reading kernel 2.6.x release notes in which it was stated that SMP support was improved for speed.

>Test stuff! Compare stuff! You have no startpoint for anything if you
>don\'t do that. Study the notes in the firebird.conf file to get an idea of
>what the various parameters can achieve.

Yeah, I know, I was wondering if somone had done it already;)

Regards,
R. Kruk