This was great. The mention of deadlocks at the end makes me wonder if there's also some transaction isolation settings to adjust.