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