Ok.. I'm a but confused, but I'm managed to get the loading time down to: 2 minutes for the first go, and 30 seconds for each consequetive.
I used the query above and removed lazy="false" fetch="join" from the hbm.xml file. When watching log4net, I can see that even though children are left outer joined in the query, it calls the database 10,000 times to get the collection of children? Why does lazy=false and fetch=join force it to refetch the children in seperate calls?
