Re: [firebird-support] Deadlock error from firebird during midnight

2017-12-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
01.12.2017 17:32, j...@codework-solutions.com [firebird-support] wrote: > I got this errors only during midnight. Thereafter it's working fine. It may pretend to work fine, but using default transaction isolation level in .NET provider is just a disaster waiting to happen. It is the reason

Re: [firebird-support] Deadlock error from firebird during midnight

2017-12-01 Thread j...@codework-solutions.com [firebird-support]
I got this errors only during midnight. Thereafter it's working fine. Get Outlook for Android From: LtColRDSChauhan rdsc1...@gmail.com [firebird-support] Sent: Thursday, 30 November, 8:29 PM Subject: Re: [firebird-support] Deadlock error from firebird during midnight To:

Re: [firebird-support] Gradual decrease in select performance - Indexes

2017-12-01 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, 1. Show us stats from gstat -h from working system i do not belrve that you have 3 transactions working whole the time. I suppose here that you have transaction management problem - i guess2. Consider bigger page size but i do not know how your insert/update scenario looks like and if this

[firebird-support] Gradual decrease in select performance - Indexes

2017-12-01 Thread 'David Hollings' david.holli...@parcelperfect.com [firebird-support]
Hi all, We use Firebird 2.5.7 CS 64bit on Centos. We notice that things slow down gradually over time, eventually calling for a backup and restore cycle. Thereafter performance returns and slowly worsens over time. We know that rebuilding an index will dramatically improve query performance. An