[firebird-support] Re: Problem with application that creates hundreds of transactions per minute

2015-12-19 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
Here are some more details. I used GBAK to backup and then restored the database. Here are the gstat details: Database header page information: Flags 0 Checksum12345 Generation 30 Page size 4096

Re: [firebird-support] Re: Problem with application that creates hundreds of transactions per minute

2015-12-19 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
I read that CONSISTENCY imposes table locking even for read operations which means that I will continue using CONCURRENCY mode. Additionally, I will not run both update processes at the same time to avoid the problem I have been having. On Sat, Dec 19, 2015 at 11:01 PM, Caroline Beltran <

Re: [firebird-support] Re: Problem with application that creates hundreds of transactions per minute

2015-12-19 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
Alan, I think you are right. I backed up then restored my database. Next I installed SuperServer and everything was going very well. Here are my stats: Database header page information: Flags 0 Checksum12345 Generation