>We have run into a situation with a VFP8 database on a small peer to peer network. When a user tries to save a record, a message "Waiting on Lock" appears and it takes a long time before they can start entering the next record.
This seems to indicate that two users - or two forms, or two EXEs, on the same machine - are trying to lock the same record.
>We have Table buffering set to pessimistic row buffering. Would it help to change to optimistic row buffering?
I think this is quite possible: pessimistic buffering locks records as soon as the user starts modifying, if I understand correctly. Optimistic buffering will only lock the record when the user saves. This greatly reduces innecessary locking, as well as locking for too long a period.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)