How well does hibernate perform ?
A lot has been said and discussed about hibernate performance.I will not go into details and benchmarks but I will share some practical insights.
Our application was developed using Spring framework 2.5 , spring webflow and hibernate 3.0. We had Oracle application server (not the oracle weblogic ) and oracle database 10g
Caching : Second level caching was done using ehcache. The caching strategy was read-only which is the simplest and best-performing cache strategy
Stored Procedures : Procs were used at couple of places. These procs had business logic and were communicating with another database through DB Link.
Native queries : We did not use any native queries.
We have used Spring and hibernate with one of the biggest deployment in applications and I can tell you, I have not seen any issues or so because of hibernate.
Yes we had to fix the hqls at few places but that is a normal tuning process.
I cannot share much details here neither the performance statistics but will be happy to answer your questions.