At 05:29 AM 9/22/2004, Pavel Cisar wrote:

>About NOWAIT option, it has it's use especially on write-only
>transactions to detect collisions between concurrent updates more
>quickly. Because all transactions normally end as committed, it's
>pointless to wait on outcome of blocking one.

With the caveat that in a contentious environment waiting
for the commit/rollback can avoid live lock.


Regards,

Ann