Subject Re: [firebird-support] Re: Active transactions (benchmark results - updated)
Author Ann W. Harrison
k_smith_000 wrote:
>
> The shorter hash chain, the faster object lookup.
> Do the LockHashSlots has any impact on the speed on hash function?
> If not, why can't we set LockHashSlots to maximum value...

You can set it to 2039 - There's some merit to not leaving a lot of
empty slots - wasted space and my reluctance to do so is probably the
result of growing up during the great bit depression.

For reasons obscure, the max value allow for hash slots is 2048. The
evidence is that using 2048 gives worse distribution and 2039.

Regards,


Ann