Efficient way to do bulk/batch INSERTS | Spring Boot | JPA | Performance tuning & Optimisation

Spring Boot | Bulk insert API with Spring JPA Batch insert | Performance tuning & Optimisation.

url: jdbc:mysql://localhost:3306/bookstoredb?rewriteBatchedStatements=true

Git link for this project:

How to do bulk (multi row) inserts with JpaRepository?
Bulk insert with Spring Boot and Spring Data JPA?
Efficient way to do batch INSERTS?

You can also find me on:

#codesimple #springboot #buikapi #bulk #insert #performance #optimisation #correct #way #jpa #batch

[viniribe]

In my data import, this optimisation were very impressionnant.
Execution time initial of 5 minutes
After changes, 10 seconds


Great! Thanks

[karthika]

Hi your all videos are very helpful. Thank you.

[sakshamsharma]

Thank you soo much bro you solved a big problem for me

[ZxbinhjxZ]

19:05 I still see many insert into sql on each record, not combine them into 1? seems rewriteBatchedStatements=true not working

[bhargavnreddy]

We can use namedparameterjdbctemplate from spring jdbc for faster inserts

[kamalraju]

how can we enable the batch insert property for postgresSql DB?

[sachinmunji]

What if we are handling insert and update both through same api.. How can u avoid inserting duplicate

[rabinarayansabat]

But this increment strategy won't work in distributed system. So what need to be done then

[paulcainca]

Please can you point me to the tutotial that creates the underlying bookstore-api

[KakarlaNagendraBabu]

hi bro, In this video ur way of explanation is good, i have a one doubt for inserting bulk data with using spring batch is there any chance to make video

[cameraman]

I haven't been able to do batch inserts when one of the entities have a @UniqueConstraint, it complains 'duplicate key value violates unique constraint'. Which makes sense because it is assigning it an id +1 of the one previous even though they have the same supposedly unique property. I'm trying to find a way so that it recognizes that it is the same entity, been trying for a few days without success.

[yashaswisharma]

Hi Sir,
Can you please show the same scenario with MS SQL database.

[pureScalper]

I am using same process for ms SQL but first it firing select query for same number of records....then it firing batch insert as per set value. Can you please tell how to disable select query and directly firr insert?

[avinashkv]

I can't able to see the save method inside your repository

[dheebanm]

How to fetch 10 million records optimise way pls?

[vinayakbt]

How to update record in bulk, I mean how to update list of records at a time like bulk insert

[arjunsworldadv]

Don't use increment with multiple instances