Item 46: How to Batch Inserts in Spring Boot Style
Batching is a mechanism capable of grouping INSERT, UPDATE, and DELETE statements and, as a consequence, it significantly reduces the number of database/network round trips. Fewer round trips usually results in better performance.
Batching can be the perfect solution for avoiding performance penalties caused by a significant number of separate database/network round trips representing inserts, deletes, or updates in a database. For example, without batching, having 1,000 inserts requires 1,000 separate round trips, while employing batching ...
