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.

We have Table buffering set to pessimistic row buffering. Would it help to change to optimistic row buffering?

Any other suggestions on speeding up data entry would be appreciated.

Thanks in advance.