Re: [firebird-support] no-wait vs wait transactions?

2014-07-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 9, 2014, at 3:09 PM, jonatan.laurit...@yahoo.dk [firebird-support] firebird-support@yahoogroups.com wrote: 1) Almost all of A-transactions end with success in my case, so almost always B-transactions will fail with deadlock message anyway. Therefore the wait mode has no

Re: [firebird-support] no-wait vs wait transactions?

2014-07-09 Thread jonatan.laurit...@yahoo.dk [firebird-support]
Just some notes. 1) Almost all of A-transactions end with success in my case, so almost always B-transactions will fail with deadlock message anyway. Therefore the wait mode has no advantages in my case. 2) There are floating around some stories from my clients that the deadlock messages can

[firebird-support] no-wait vs wait transactions?

2014-07-08 Thread jonatan.laurit...@yahoo.dk [firebird-support]
Hi! I have Firebird 2.x database which from time to time has rather long transactions - up to 30 seconds and so, there is high probability that the same record will be updated from the several different transactions and the lock conflict - deadlock exeption will be raised. I am currently using

Re: [firebird-support] no-wait vs wait transactions?

2014-07-08 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 8, 2014, at 3:37 PM, jonatan.laurit...@yahoo.dk [firebird-support] firebird-support@yahoogroups.com wrote: I have Firebird 2.x database which from time to time has rather long transactions - up to 30 seconds and so, there is high probability that the same record will be updated

Re: [firebird-support] no-wait vs wait transactions?

2014-07-08 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Not to make you jealous or anything, but we just came back into cell phone range o n our leisurely cruise down the Maine coast. I'd send a picture, but the list won't let me. Now it's 6:30. The drinks flag is out; the dog has had her run through the woods and a bit of swimming. Life is