Subject RES: [firebird-support] For those who think they have performance problems
Author Fabiano - Desenvolvimento SCI
Post date 2014-02-21T11:14:32Z

I belive!
We use 20011.

When we raised to 20011 performance is much better and memory consume is a little bit more.

I think FB developers must increase a lot the default value, specially with upcoming FB 2.5.3

 

De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Alexey Kovyazin
Enviada em: sexta-feira, 21 de fevereiro de 2014 07:38
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] For those who think they have performance problems

 

 

 

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