On Mon, Jun 14, 2010 at 11:58 AM, Dave Crooke wrote:
> If you're doing straight SQL bulk updates, then as someone suggested, you
> could use an ORDER BY on a subquery, but I don't know if that is a guarantee,
> if you're not actually displaying the results then the DB may be technically
> allow
It's a standard (indeed, required) best practice of concurrent database
programming across any brand of database to ensure that multi-row
transactions always acquire the locks they use in a predictable order based
on row identities, e.g. for the classic banking debit-credit pair, doing
something li
