Hi,

we are completing a project with hibernate but have stumbled upon a performance problem when retrieving a list of about 100 objects.

The objects are retrieved with a named query in hibernate, but as I see from my logging, hibernate really is the bottleneck as mapping the database results to the objects takes up most of the time.

Retrieving myself a list costs about 9 seconds, and while I perform that SQL query on the database, the data is retrieved in less than 1s. I have defined lazy property fetching for the props I don't need but it appears not to be sufficient :(

Is Hibernate not up to such a task to retrieve lots of objects at one pass? What could I do to improve that performance?

Thank you,
Steven

Hi,
First confirm that your session is not bloated with persistent objects. If true, it eats up a lot of space and can slow down the application. Try this,
....
session.flush() ;
session.clear() ;
// My query
.....

-------------------------------------------------------------
Rate the answer if you find it helpful