Re: A row locking problem that baffles all...
From: Alexander I. Doroshko <aid_at_grant.kharkov.ua>
Date: 15 Jan 1999 09:19:15 GMT
Message-ID: <01be4068$0613f420$190114c1_at_sister.grant.UUCP>
Date: 15 Jan 1999 09:19:15 GMT
Message-ID: <01be4068$0613f420$190114c1_at_sister.grant.UUCP>
May be, a smaller evil in this case is
- not to lock the record while updating;
- lock it with NOWAIT before committing;
- in case of success check while committing if the record was changed by another user;
- in case of not success ask the user to repeat the work.
It can be useful, if the record updating process takes relatively few efforts, and the lock time minimizing is vital.
--- Alexander I.Doroshko, aid_at_grant.kharkov.ua * Bank "Grant", Kharkov, UkraineReceived on Fri Jan 15 1999 - 10:19:15 CET