Improve performance for batch operations [DATAJDBC-314]

[spring-projects-issues]

Ioannis Daskalakis opened DATAJDBC-314 and commented

Currently, SimpleJdbcRepository batch operations (saveAll, deleteAll) are performed by iterating all instances and performing the operation for each instance separately.

Utilizing batching on the jdbc level (e.g. by utilizing NamedParameterJdbcOperations::batchUpdate) would offer significant performance improvements.

  

---

Issue Links:

• DATAJDBC-328 Implement saveInBatch, deleteInBatch methods
  ("is duplicated by")

11 votes, 12 watchers

[spring-projects-issues]

cn-src commented

Add batchInsert and batchDelete very good

[spring-projects-issues]

deleted commented

Looks like duplicated by DATAJDBC-328

[cemo]

I think supporting batch operations is essential.

[ToddyuLi]

any plan on this? I need it too!!

[vtrusevich-incomm]

Are there any plans for this feature?

[dereknheiley]

How is this still not a thing? Where do i push a PR for it?

[schauder]

@dereknheiley https://github.com/spring-projects/spring-data-jdbc/pulls
Also see https://github.com/spring-projects/spring-data-build/blob/main/CONTRIBUTING.adoc