3.3 Using Batches to Do a Lot of Work Without Blocking

Let’s say we need to do a lot of work: Delete all of the Users whose Location = ‘London, United Kingdom’ Plus delete all of their rows in related tables: Badges, Comments, Posts, and Votes We could try doing it in one giant transaction, but that’s going to take out exclusive locks on a lot…

To access this incredible, amazing content, you gotta get Mastering Query Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

Menu