--- In firebird-support@yahoogroups.com, "s3057043" <s3057043@...> wrote:
...
> > Increase your hash table size.
>
> I will have that changed to 2039. (Presumably the service needs to be restarted for changes to take effect).
You have avg hash len = 10. Double hash slots and avg hash len will be shorter two times, i.e. you can expect 5. I'd increase hash slots by 5-6 times for the start.
And no, you don't need to restart service - full disconnect is enough. First connection will re-create lock table using new parameters.