In my project we are facing performance related issues because of the DB design ,We cannot change the DB structure.

The issue is because we have 4 levels of nesting of objects with one to many relationships between them.
A (1-*) B (1-*) C (1-1) D

I cant lazy load them also I need to load all of them initially itself due to the project requirement.

If A had 10 rows, for each A row there were 10 rows in B and for each row in B if there were 10 rows in C and for each row in C we had one row in D.

Still it needs to make , Is there any way to handle this scenario.

Please help me in handling this performance issue.

Thanks,
Venkat.

Could you be a little more specific? What do you mean with "hits" the number of database rows required for you're data? The number of SQL statements? The amount of data transfered via JDBC?

What I meant to say was the number of SQL statements executed .

Ok, so you should check you're query statements (are you using hql?) and try to fetch more than one row in a statement. Maybe you should also check you're mapping. You can use "select-join" to get collections with an outer join instead of an separate select.