Large batch operations cause table locks and memory spikes

Too large batches lock database tables excessively or cause memory spikes. Sweet spot depends on database backend and hardware.

Size batches appropriately: PostgreSQL handles 1000-row batches smoothly, MySQL benefits from smaller chunks around 300-500. Monitor with pg_stat_statements or slow query logs.