Hi All,

We've developed a web application using struts and hibernate. Now when we tried the load testing of the application, the application failed because of the number of queries it hit for a particular transaction. I have browsed different sites to find out the basic tuning that can be done to hibernate so that the performance can be increased. Please suggest any changes that can be made to the Hibernate configuration.

Presently we are using a lot of sql queries within hibernate. All the mappings done are just default i.e basic mapping tags are used(CLASS and TABLE). Most of the queries are "SELECT" queries and based on entity specific value(Hibernate proxy??).

Also inside hibernate.cfg.xml the properties we are using only show_sql and format_sql.

Please guide.

Thanks,
Sandeep

Hello Sandeep,

Its obvious there are Select queries. You have to note that queries will be fired not only when u write sql/hql, it will be fires when accessing the reference objects. So its always best to join the reference tables/entity before u query the table in a single fetch. There are configurations where we can make to load the entities in cache. That can be done through ehcache . Your question is generic and cant be answered if you are looking for solution.

Hi Shynate,

The problem i have here is all the joins and dependency's between the entities are defined at DB level not in hibernate mappings. So is there any properties and fetching techniques i can set to increase the performance, like batch fetching or some other properties i can set ?

Does sql queries degrades the performance over hql ?

Any opinion on the hibernate 2nd level cache?


Thanks,
Sandeep