Subject Re: [firebird-support] Firebird 2.5 conf for high load multiple and quick connections
Author Mark Rotteveel
On 17-7-2014 16:51, rudibr@... [firebird-support] wrote:

> TempDirectories = D:\FIREBIRD_TMP;D:\WINDOWS_TEMP
>
> DefaultDbCachePages = 512
>
> TempBlockSize = 8388608
>
> LockMemSize = 10097152
>
> LockHashSlots = 60540

The documentation of LockHashSlots says:
# Tune lock hash list; more hash slots mean shorter hash chains. Only
# necessary under very high load. Prime number values are recommended.

I'd suggest 60589 (the first prime after 60540).

--
Mark Rotteveel