Readu locks should always be for the shortest period of time.  Having locks
open for long periods of time can cause issues such as the lock table
filling up causing other issues.  The performance issues can be significant
and this is why RDBMS go to optimistic locking.   

Unless the record is locked because someone opened the record and went to
lunch, it may be better to consider other methods.  If it is related to
workflow processes consider using task synchronization locks.

Regards
David Jordan
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to