Subject Re: [firebird-support] For those who think they have performance problems
Author Alexey Kovyazin

LockHashSlots to 8191. ;-)



We have set 31013.

Today situation is much better, users are surprised with +30% speed increase, with 700 active connections:

LOCK_HEADER BLOCK
        Version: 145, Active owner:      0, Length: 75440168, Used: 28721584
        Flags: 0x0001
        Enqs: 3143976306, Converts: 1574782, Rejects: 253168, Blocks: 6607562
        Deadlock scans:      0, Deadlocks:      0, Scan interval:  10
        Acquires: 3197419523, Acquire blocks:    673, Spin count:   0
        Mutex wait: 0.0%
        Hash slots: 31013, Hash lengths (min/avg/max):    0/   2/  11
        Remove node:      0, Insert queue:      0, Insert prior:      0
        Owners (736):   forward: 1369256, backward: 20828544
        Free owners (35):       forward: 6090320, backward: 10504960
        Free locks (4172):      forward: 262208, backward: 20547568
        Free requests (14944):  forward: 17197144, backward: 3648808


Regards,
Alexey Kovyazin
IBSurgeon