|Subject||Re: [firebird-support] Current isolation level used?|
|Author||Ann W. Harrison|
> Christianto Tjahyadi wrote:Aage Johansen wrote:
> > Btw, how to know the current (active) isolation level used? Also, how to set
> > the deadlock time out?
>The deadlock timeout is 10 seconds, by default, and you probably don't
> ...Don't know a thing about "deadlock time out".
want to change that. A deadlock scan is expensive. But that's probably
not what you want. You probably want a blocked update or delete (i.e.
Update Conflict) to time out. That's a V2 feature. For earlier
versions the choice is an immediate error (no wait) or waiting until the
blocking transaction completes.