Subject | Re: [firebird-support] READ ONLY READ COMMITTED and consistency |
---|---|
Author | Ann W. Harrison |
Post date | 2010-05-16T14:54:04Z |
Michael Ludwig wrote:
the most recent version of a record at the time of the read.
If you read the same record twice, you may see different values.
If you count the same set of records twice, you may get different
numbers. That's why I recommend REPEATABLE READ, which, in
Firebird is not only repeatable, but excludes phantoms.
Good luck,
Ann
> In a transaction configured with READ ONLY READ COMMITTED, is itYes, of course. That's what the READ COMMITTED mode does - reads
> possible to see just part of a commit?
>
the most recent version of a record at the time of the read.
If you read the same record twice, you may see different values.
If you count the same set of records twice, you may get different
numbers. That's why I recommend REPEATABLE READ, which, in
Firebird is not only repeatable, but excludes phantoms.
Good luck,
Ann