• I'd agree with both points above. USe batches, and if you can test, try dropping indexes.