[
Lists Home |
Date Index |
Thread Index
]
-----Original Message-----
From: CHIUSANO, Joseph [mailto:JCHIUSANO@lmi.org]
It seems reasonable to assume that when committing this information to a
database, one may have to lock multiple tables simultaneously (thereby
violating the best practice rule of "hold locks for as little time as
possible"). That is, the Order table would need to be locked, then the Item
table (while the Order table is locked), etc.
Why the assumption of table-level locking? Neither do I see how the
structure of the XML document matters, assuming you have a database that
supports optimistic concurrency and atomic transaction commitment.
However, if you're using MS-Access in a multiuser environment, there's no
hope for you anyway. :-)
|
