Subject Re: AW: [firebird-support] Big database, transactions and performance
Author Ann W. Harrison
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.