Hi Guys,

I am Running Firebird Super Server 1.5 RC8, on Win 2K sp4, 1.6 Gig Ram, PIII 800mhz, Page size 4096. Only 1 databse of about 300 Mega. 50 local users on al 100mb LAN.


I am confused about how to configure better the following parameters, and I will appreciate your help:

#DefaultDbCachePages = 2048 (8192 K)
DefaultDbCachePages = 82944 (331776 K) (Because the only DB is about 300 mega)

#SortMemBlockSize = 1048576 (1024 K)
SortMemBlockSize = 16777216 (16384 K) (Because we have some "Selects" that returns about 64 Mega, so I guess it has to be Sorted in ram first)

#SortMemUpperLimit = 67108864 (65536 K)
SortMemUpperLimit = 268435456 (262144 K) (I guess this is about how much ram can be allocated to sort at 1 time for all users, and I calculated a maximum of 4 users sorting 64Meg each)

#TcpRemoteBufferSize = 8192 (8 K)
TcpRemoteBufferSize = 24576 (24 K) (Just to give a bigger buffer to the users)

#LockMemSize = 262144 (256 K)
LockMemSize = 786432 (768 k) (No idea what this is, but just in case...)

#EventMemSize = 65536 (64 k)
EventMemSize = 131072 (128 k) (No idea too)

#PrioritySwitchDelay = 100
PrioritySwitchDelay = 150 (Because the processor is a poor PIII 800 with 50 users killing it, I guess 50% delay is good)

#IpcMapSize= 4096 (4 k)
IpcMapSize= 24576 (24 k) (No idea, but maybe something like the TcpRemoteBufferSize??)

Many Thanks
Fabian.

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