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/