Which is the time spent using only ADO.NET loading a similar DataSets (mean same info of main+related entities) ?
2009/2/12 Chucara <[email protected]> > > I'm just starting to pick up nHibernate having initially tried MS > Entity Framework and found some showstopper performance issues. Now, > I'm running into some with nHibernate. I'm pretty convinced that I > must be doing something wrong, so what is it? > > An example: > > I have a single class, PROJ_COMP. This class has a ISet of PROJ_COMP- > Children. Defined as follows: > > <set name="Children" fetch="join" lazy="false"> > <key column="PARENT_PROJ_COMP_NO"/> > <one-to-many class="PROJ_COMP"/> > </set> > > and > > public ISet<PROJ_COMP> Children { get; set; } > (in the PROJ_COMP class) > > The following takes AGES to perform: > > var lst = _session.CreateQuery("select pc, chld from > PROJ_COMP as pc "+ > "left outer join > pc.Children as chld "+ > "where pc.PROJ_NO = 147 and > pc.PARENT_PROJ_COMP_NO is null").List(); > > What am I doing wrong here? My best estimate is that it takes 1 hour > 20 minutes where Entity Framework does the same in 1 minute. > > In plain English, my goal is to eager load all parent components and > all their children. > -- Fabio Maulo
