Until you benchmark it for your app you really don't know how
inefficient it really is compared to pessimistic locking.
Sure. The question was about more about finding the right approach/layer for implementing pessimistic locking so that comparisons *could* be made.