Erik Darling has some thoughts on batching data modifications:
The whole point is to go a little bit easier on your server:
– Smaller transactions sent to the log file
– Shorter locking durations
– Less build up of the version store (optimistic isolation levels, triggers, etc.)
But there are thing that make batching impossible, or downright tricky.
Erik provides more details after the jump. This is all “stuff you should think about” rather than “reasons why you shouldn’t batch.”