There is a good article on optimistic vs pessimistic locking
https://medium.com/@aslrousta/pessimistic-vs-optimistic-locking-in-laravel-264ec0b1ba2
The result suggests optimistic locking is the way to go. You might find this package useful.
Hi Friends, I have designed patient appointment system in which sound chance to update same record by many users , I am seeking for export advice which locking mechanization is best to adopt pessimistic or optimistic , I am thinking to give user 10 second for update and refresh the web page in case user not responded please help me
Please or to participate in this conversation.