prageeth
Reputation: 7395
Hibernate batch_size best value
Can anybody advice me how to choose the best value for hibernate.jdbc.batch_size?
If memory and CPU is not a problem, is it ok to use a value like 500?
In this chapter, it says to use a value between 10 and 50, but it didn't give a reason. Can anybody provide an explanation for this limitation?
Upvotes: 6
Views: 9023
Answers (2)
JB Nizet
Reputation: 691735
The Hibernate documentation recommends a value between 5 and 30. The best value is entirely dependent on your app, your data, your database. Try various values and measure the performance of each one.
Upvotes: 5
Related Questions
- Understanding @BatchSize in Hibernate
- Drawbacks of a high hibernate.jdbc.batch_size setting
- Setting Hibernate Fetch/Batch size in Spring-Boot
- default_batch_fetch_size recommended values
- Changing hibernate batch size programmatically
- Printing hibernate.jdbc.batch_size
- Hibernate JDBC Batch size is not working
- Hibernate batch size confusion
- Is hibernate.jdbc.batch_size useful at all?
- Setting Batch size in configuration