[nhibernate-development] Re: Loading related data gives lousy performance

[Chucara]

Ayende: Are you saying I should do this instead:

select pc, chld from PROJ_COMP as pc
left outer join fetch pc.Children as chld
where pc.PROJ_NO = 147 and pc.PARENT_PROJ_COMP_NO is null

I will try this.

Data size is: 10,000 parent components, 10 subcomponents each. (It's
basically a stress test)