Hi,

I just ported my app from Ibatis to Hibernate because
some high placed guys just chose Hibernate as our official ORM system.
It was relatively easy to learn. The port was finished in 3 days.

Now the big surprise: Performance went from 9 secs to 145 secs!!!!

Profiling shows that most of the time is spend in thefind statement below:


List list = session.find("from com.accovia.domain.Supplements as supp where "
+ "supp.codeSupplId = ? and supp.periodeId = ?",
new Object[] { new Long(codeSuppl), new Integer(periodeId) },
new Type[] { Hibernate.LONG, Hibernate.INTEGER });


I would like to ask these questions:

1. How I can make the above find faster ?
2. Can I know if it is translated to a prepared statement or not?
3. Should I transform the find into a load statement ? (by adding an index)

thanks
/thanh nguyen/

NB: All of this is true.

By reading the Hibernate documentation and understanding how to use proxies and/or outer join fetching.

It helps to enable SQL logging, so you can see what Hibernate is actually *doing*, so that you can then optimize this.

You probably have an n+1 selects problem.




It is using a prepared statement, as always.