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

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

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?

Muchas gracias estimado 😉

Hi your all videos are very helpful. Thank you.

Don't use increment with multiple instances

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

Many thanks.

good job

We can use namedparameterjdbctemplate from spring jdbc for faster inserts

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.

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

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

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

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

How to fetch 10 million records optimise way pls?

Very useful sir 👍

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


Great! Thanks

Can we read in batches as well?