Hi,

I am facing an optimization issue with a Query(HQL) which fetches around 400 records from the database and has 15 associations in the hbm mapping file.

The associations are getting fetched Eagerly, still the query is taking around 10 secs to execute.

I have tried using detached criteria but the execution hangs because of the left outer joins.

please provide some pointers on this as to how this could be optimized.

-Sameer

You can use subselect fetching if you have a lot of relation

http://www.hibernate.org/hib_docs/v3/re ... e-fetching

Join fetch is not recommended for more than one '*-to-many' association

Hi,
Thanks for the reply, but the problem that i am facing is due to many-to-one mappings and not the other way around.
That's why subselect is not going to work, since HQL is already making it work like a subselect and repetitive selects are bringing the performance down .

-Sameer