Christian Waldmann wrote:

>
> My design uses WITH LOCK and noWait transactions. So there is an
> exception when the records is already in use. After a short period I
> retry to access the record.
>
> Is your proposal to use the queries without the LOCK and to catch the
> exceptions when an update conflict arises? Is this less load for the
> server?

Vastly less.

Best,

Ann