Hello everyone,

I am trying to load from the database a list of objects (lets say 1000 objects), each of them having associated some 12 objects... they could be considered object graphs.

As you can imagine, I have troubles with performance issues, as it takes some 10 minutes to load everything.

My question is how can I improve the load time? I believe that the trick is in fetch the records using joins instead of selects or subselects. I have tried this but without any spectacular improvement.

Has anyone experiences this problem ? How did you manage to solve it ?

Thank you,
C.

Problem solved. I have used join fetch to retrieve the references, and subselect fetch for the collections. Works like a charm ! ;)