I think this would be a difficult question to answer, without knowing the specific case why you are getting deadlocks. What you want for best performance is op

I think this would be a difficult question to answer, without knowing the specific case why you are getting deadlocks. What you want for best performance is optimistic concurrency control. Which means that you need to allow for "deadlocks happen".