Re: [firebird-support] For those who think they have performance problems

2014-02-21 Thread 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:

RES: [firebird-support] For those who think they have performance problems

2014-02-21 Thread Fabiano - Desenvolvimento SCI
] 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

[firebird-support] For those who think they have performance problems

2014-02-20 Thread Alexey Kovyazin
Hi All, Just got an amazing lock print. This is real performance nightmare :) LOCK_HEADER BLOCK Version: 145, Active owner: 63554144, Length: 210763776, Used: 209783832 Flags: 0x0001 Enqs: 21025066275, Converts: 82460471, Rejects: 64835339, Blocks: 594096759 Deadlock scans: 61,

RES: [firebird-support] For those who think they have performance problems

2014-02-20 Thread Fabiano - Desenvolvimento SCI
] For those who think they have performance problems Hi All, Just got an amazing lock print. This is real performance nightmare :) LOCK_HEADER BLOCK Version: 145, Active owner: 63554144, Length: 210763776, Used: 209783832 Flags: 0x0001 Enqs: 21025066275, Converts

Re: [firebird-support] For those who think they have performance problems

2014-02-20 Thread Thomas Steinmaurer
Hi All, Just got an amazing lock print. This is real performance nightmare :) FYI: A check-in in trunk from Feb. 17th increased the default value for LockHashSlots to 8191. ;-) -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB