Hi All,

I came across this post that had (surprisingly) zero responses, so thought to highlight it and at this same time ask the group:

Q. Where are the best (freely-available) sources of information that deal solely with optimisation & configuration of FB? I've searched for it and haven't been able to easily find it.

The TcpRemoteBufferSize value is of particular interest currently but anyone that might also like to comment on some of Fabian's values (as a starting conversation point) would be good too.

It is understood that the many deployment scenarios call for different values so responses of the form 'it depends' are unnecessary. Rather, examples of any default configuration values that you always change (as you feel they are too low/insufficient/etc) would be good plus 'real-life' improvements that were found by experience (in a given scenario).

Thanks,
Tom

--- In firebird-support@yahoogroups.com, "Fabian Chocron" <fabianch@...> wrote:
>
> 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]
>