Update hot rows last

(Mark Callaghan) How do you get more throughput from a workload that has a lot of concurrency and transactions that contend on updating the same rows? Move the updates for the contended rows to the end of the transaction. This is a good problem to prevent as it is very hard to diagnose on production

Read More - Register for Free Membership