Subject | Design problem |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-06-20T10:59:43Z |
Checked with the development manager. What seems to be happening is that a
select query is run against the DB, with txn isolation of read consistency.
When we try to make a sale (txn isolation of write consistency ) or close a
shift, the sale or shift txn waits until the select is closed. In other
words, doing a select with read consistency seems to lock the record set
returned by the query.
Thanks
Tim
[Non-text portions of this message have been removed]
select query is run against the DB, with txn isolation of read consistency.
When we try to make a sale (txn isolation of write consistency ) or close a
shift, the sale or shift txn waits until the select is closed. In other
words, doing a select with read consistency seems to lock the record set
returned by the query.
Thanks
Tim
[Non-text portions of this message have been removed]