I am looking for some statistics on the performance of Hibernate ORM when dealing with tables having a huge number of rows.

Assumptions: I will be using MySQL as the database. Connection pooling and Second Level Cache will be enabled.

Questions - With the increase in table size:

  1. How operations like Create, Read, Update, and Delete will get impacted?
  2. How search performed using PK will get impacted?
  • I am not a veteran in Hibernate,so i can't really answer this question.In general,Hibernate saves you time writing SQL statements and executes them in groups,which reduces the "how many times" you hit the database.I don't think that the hibernate does some performance tuning depending on the number of the rows in your table(if that's what you are asking). – Barracuda Sep 20 at 19:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.