Hello,

I have simple model like :


I have a lot of Employees (> 5 000 000), who have some tasks (100+) and some addresses (10+).


I already read and try fetching strategies exposed here : http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/performance.html
But I'm not convinced by any (too many sql requests).

Is there a way to have SUBSELECT fetching with query.scrool(ScrollMode.FORWARD_ONLY) ?

How do you do this kind of work ?

Thanks

Can't you use the dump mechanism of your database? Like EXP in Oracle?

Or you could dump just a single table in one step. What format do you need in the output? If you do a "plain" dump of each table you have IDs and foreign keys to import data again if needed.