Hi there,
I have (again) performance problems on one service methods of my applications.
I retrieve a huge quantity of instances of one entity.
And i process (read from) each entity sequentially (which means as well load the associated entities/associations since i use a lot of lazy loading)
At the beginnin, this works quickly (one instance is treated in 100ms), but after a while, the process takes longer and longer (700 ms)

I don't know what this comes from? Could it be any memory overload / cache overload problem?

Am using Hibernate 3.1.3.


Thanks in advance!!

Nico.

First record time it takes to load the parent entity, then time it takes to load the associated entity (which are lazy loaded). Get the SQL query from logs and execute it in SQL client for your database. Look for a chance of optimizing the SQL query that Hibernate generates. Then you will get an idea of what to do in HQL or Critieria queries.


Then decide if you can pull only the required results (query pagination).

Finally, it is always better to add the entities to second level cache & query cache.

You can also depend on session statistics to optimize your queries and improve performance.

Thanks