Using Optimistic Locking Wherever Possible

Another strategy to work around the fact that page locking locks an entire page of data instead of just the record or records being edited is to use optimistic locking wherever possible. Although optimistic locking does not eliminate all page locking problems, it does minimize the amount of time that a record is locked and therefore minimizes the possibility that an unwanted record will also be locked.

See Also For more information about optimistic locking, see “Optimistic Locking” earlier in this chapter.