Win a copy of Kubernetes in Action this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Bulk updates vs Sql query to update bulk records in Hibernate  RSS feed

Ranch Hand
Posts: 189
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

Currently to update a bulk of records , say around 2000,I first load the records in the session, iterate over it and then update it.
This is taking tremendous amount of time, say around 10-15 mins or so.

I was thinking of optimizing this part of the code.
After doing a research, i have found that we can do bulk updates in hibernate by setting the jdbc_batch_size in hibernate and then do session.flush() and session.clear().

I just want to know that in bulk updates a single query is fired for 'n' records (where n in the number assigned to jdbc_batch_size) OR a query is fired for each record?

Also, if instead of using bulk updates, if i go forward with writing a procedure or a join sql query, which approach will give me better results performance wise?

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!