Hi,

We maintain two legacy systems one with 261 tables, more or less 548 classes and 82.192 lines of java code.

The problem is that our framework has migrated from hibernate-core-3.6.10.Final to hibernate-core-4.2.15.Final.jar, and
after the migration the pages with lots of queries take almost 10 times more than before.
We resorte to check database logs and we see that the system uses twice the SQL commands, it seems that the default fetch strategy has changed from eager to lazy.

With the old versión 3.6, with eager fetch default, we use to control the tree depth with fetch_depth to 1 in configuration and everything works very performant.

We are looking for a way to set the default fetch strategy to eager like before, due to the size of the system we are looking for a way to make it globally not class by class.

Any help will be appreciated,

Thanks for reading,

Hans Poo, Welinux S.A.
Bombero Ossa #1010, oficina 800,
+56-22-3729770, Movil: +56-9-3199305
Santiago, Chile