Batch inserts using JPA EntityManager

Depending on whether the transaction encloses the loop, batching typically already happens in your case.

JPA will collect all your updates in its L1 cache, and typically write that all to the DB in a batch when the transaction commits. This is not really that different with batching in JDBC, where every batch-item you add is also temporarily in memory until you call an update method.

Potentially problematic is that you don’t have hard guarantees that JPA indeed does this batching at all and if does this at transaction commit or when a threshold is reached, but I found that in practice in nearly all cases and especially in cases involving such a simple update loop, it indeed does batching.

One problem is that even if JPA indeed already does batching you still may want to control batch sizes. The articles linked by the other answers provide pretty useful information for that.

Finally, you should be aware that your L1 cache keeps growing in a loop, so if the number of updates are really large, periodically clear it. Alternatively, if your business logic can sustain it, do partial updates in multiple transactions. E.g. item 0 to 100.000 in transaction 1, 100.001 to 200.000 in transaction 2, etc.

Leave a Comment