-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: Funny performance problem
PostPosted: Fri Nov 11, 2005 11:26 am 
Newbie

Joined: Fri Sep 09, 2005 2:00 am
Posts: 9
I encountered funny performance problem with IQuery.List():
(I hope that class names are self-explaining)

This query takes 9 seconds of *nhibernate time* i.e. to materialize objects:

from ProjectSubject ps inner join fetch ps.Subject s left join fetch s.Addresses a left join fetch a.Province p left join fetch a.County c left join fetch a.City city where ps.Project.ID = :projectId and coalesce(a.Flag, 1) = 1

This one takes less than 0,1 seconds and does luckily the same:

select ps, s, a from ProjectSubject ps inner join fetch ps.Subject s left join fetch s.Addresses a left join fetch a.Province p left join fetch a.County c left join fetch a.City city where ps.Project.ID = :projectId and coalesce(a.Flag, 1) = 1

regional units (Province, County and City) have one-to-many relationship with Address and latter has inverse many-to-one relationship with all three ones. Also, city has many-to-one relationship with county and county has same with province.


Top
 Profile  
 
 Post subject:
PostPosted: Sat Nov 12, 2005 7:06 am 
Contributor
Contributor

Joined: Thu May 12, 2005 9:45 am
Posts: 593
Location: nhibernate.org
Can you isolate this behavior as much as possible and send the TestCase?

You may try it in another environment to be sure that it is not due to your installation...

_________________
Pierre Henri Kuaté.
Get NHibernate in Action Now!


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.