[firebird-support] Database performance slowdown

2016-04-18 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
We are investigating an issue with one of our systems where it gradually slows down during the course of a day. We have our epos system that we write ourselves using Delphi XE2 and the IBX components. We have a group of tables that are updated during the end of sale save process. Typically

Re: [firebird-support] Database performance slowdown

2016-04-18 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Neil, > We are investigating an issue with one of our systems where it gradually > slows down during the course of a day. > > We have our epos system that we write ourselves using Delphi XE2 and > the IBX components. How does your transaction model/layer look like in your client application wit

RE: [firebird-support] Database performance slowdown

2016-04-18 Thread 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support]
Thanks Thomas, We are explicitly starting and committing our own transactions rather than relying on any auto-commit behaviour. We are running Classic (sorry I should have told you that already). I'll get our devs to checkout the MON$ tables and see what additional info can be gleaned from them.

Re: [firebird-support] Database performance slowdown

2016-04-20 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
Hi Neil, > We are explicitly starting and committing our own transactions rather than > relying on any auto-commit behaviour. > > We are running Classic (sorry I should have told you that already). > > I'll get our devs to checkout the MON$ tables and see what additional info > can be gleaned from