Subject | Re: [IBO] Transaction question |
---|---|
Author | Geoff Worboys |
Post date | 2001-03-23T08:03:34Z |
> My question now is, could a DEADLOCK appear in such a situation,Not from that user. But presumably your system will support multiple
> when a user is only READING information from a readonly
> transaction ?
users, in which case a deadlock can still occur when updates from
multiple users conflict.
Oh, actually it can appear. If you use Isolation=tiConsistency on
either transaction you effectively prevent updates to all records that
it reads. For this reason Isolation=tiConsistency is not recommended
unless this is exactly what you want to happen.
HTH
Geoff Worboys
Telesis Computing