Subject | Re: [Firebird-Architect] Supported transaction isolation levels? |
---|---|
Author | Nando Dessena |
Post date | 2005-04-05T15:12:09Z |
Thomas,
TS> Looking through different Firebird related documentations (Helen's book,
TS> IBP pdf set, ...), it seems that Firebird doesn't support the
TS> SQL-compliant transaction isolation level "REPEATABLE READ". Is this
TS> correct?
Boy, Firebird is about the only DBMS that has supported it decently,
i.e. without blocking writers, since day 0. I believe
isc_tpb_concurrency + isc_tpb_wait is what you're after. BTW that's
the default setting.
Ciao
--
Nando Dessena
http://www.flamerobin.org
TS> Looking through different Firebird related documentations (Helen's book,
TS> IBP pdf set, ...), it seems that Firebird doesn't support the
TS> SQL-compliant transaction isolation level "REPEATABLE READ". Is this
TS> correct?
Boy, Firebird is about the only DBMS that has supported it decently,
i.e. without blocking writers, since day 0. I believe
isc_tpb_concurrency + isc_tpb_wait is what you're after. BTW that's
the default setting.
Ciao
--
Nando Dessena
http://www.flamerobin.org