[ http://jira.nhibernate.org/browse/NH-766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16858#action_16858 ] payne commented on NH-766: -------------------------- http://www.gnn.com.br/forum/showthread.php?t=1000087664 http://www.gnn.com.br/forum/showthread.php?t=1000087663 http://www.gnn.com.br/forum/showthread.php?t=1000087662 http://www.gnn.com.br/forum/showthread.php?t=1000087661 http://www.gnn.com.br/forum/showthread.php?t=1000087660 http://www.gnn.com.br/forum/showthread.php?t=1000087659 http://www.gnn.com.br/forum/showthread.php?t=1000087658 http://www.gnn.com.br/forum/showthread.php?t=1000087657 http://www.gnn.com.br/forum/showthread.php?t=1000087655 http://www.gnn.com.br/forum/showthread.php?t=1000087654 http://www.gnn.com.br/forum/showthread.php?t=1000087653 http://www.gnn.com.br/forum/showthread.php?t=1000087652 http://www.gnn.com.br/forum/showthread.php?t=1000087651 http://www.gnn.com.br/forum/showthread.php?t=1000087650 http://www.gnn.com.br/forum/showthread.php?t=1000087649 http://www.gnn.com.br/forum/showthread.php?t=1000087647 http://www.gnn.com.br/forum/showthread.php?t=1000087646 http://www.gnn.com.br/forum/showthread.php?t=1000087645 http://www.gnn.com.br/forum/showthread.php?t=1000087643 http://www.gnn.com.br/forum/showthread.php?t=1000087642 http://www.gnn.com.br/forum/showthread.php?t=1000087640 http://www.gnn.com.br/forum/showthread.php?t=1000087639 http://www.gnn.com.br/forum/showthread.php?t=1000087638 http://www.gnn.com.br/forum/showthread.php?t=1000087637 http://www.gnn.com.br/forum/showthread.php?t=1000087636 http://www.gnn.com.br/forum/showthread.php?t=1000087635 http://www.gnn.com.br/forum/showthread.php?t=1000087633 http://www.gnn.com.br/forum/showthread.php?t=1000087554 http://www.gnn.com.br/forum/showthread.php?t=1000087553 http://www.gnn.com.br/forum/showthread.php?t=1000087551 http://www.gnn.com.br/forum/showthread.php?t=1000087550 http://www.gnn.com.br/forum/showthread.php?t=1000087548 http://www.gnn.com.br/forum/showthread.php?t=1000087547 http://www.gnn.com.br/forum/showthread.php?t=1000087546 http://www.gnn.com.br/forum/showthread.php?t=1000087545 http://www.gnn.com.br/forum/showthread.php?t=1000087632 http://www.gnn.com.br/forum/showthread.php?t=1000087631 http://www.gnn.com.br/forum/showthread.php?t=1000087630 http://www.gnn.com.br/forum/showthread.php?t=1000087629 http://www.gnn.com.br/forum/showthread.php?t=1000087628 http://www.gnn.com.br/forum/showthread.php?t=1000087627 http://www.gnn.com.br/forum/showthread.php?t=1000087625 http://www.gnn.com.br/forum/showthread.php?t=1000087624 http://www.gnn.com.br/forum/showthread.php?t=1000087623 http://www.gnn.com.br/forum/showthread.php?t=1000087622 http://www.gnn.com.br/forum/showthread.php?t=1000087621 http://www.gnn.com.br/forum/showthread.php?t=1000087620 http://www.gnn.com.br/forum/showthread.php?t=1000087618 http://www.gnn.com.br/forum/showthread.php?t=1000087617 http://www.gnn.com.br/forum/showthread.php?t=1000087616 http://www.gnn.com.br/forum/showthread.php?t=1000087615 http://www.gnn.com.br/forum/showthread.php?t=1000087614 http://www.gnn.com.br/forum/showthread.php?t=1000087613 http://www.gnn.com.br/forum/showthread.php?t=1000087611 http://www.gnn.com.br/forum/showthread.php?t=1000087610 http://www.gnn.com.br/forum/showthread.php?t=1000087609 http://www.gnn.com.br/forum/showthread.php?t=1000087608 http://www.gnn.com.br/forum/showthread.php?t=1000087607 http://www.gnn.com.br/forum/showthread.php?t=1000087605 http://www.gnn.com.br/forum/showthread.php?t=1000087604 http://www.gnn.com.br/forum/showthread.php?t=1000087603 http://www.gnn.com.br/forum/showthread.php?t=1000087602 http://www.gnn.com.br/forum/showthread.php?t=1000087601 http://www.gnn.com.br/forum/showthread.php?t=1000087600 http://www.gnn.com.br/forum/showthread.php?t=1000087599 http://www.gnn.com.br/forum/showthread.php?t=1000087598 http://www.gnn.com.br/forum/showthread.php?t=1000087597 http://www.gnn.com.br/forum/showthread.php?t=1000087596 http://www.gnn.com.br/forum/showthread.php?t=1000087595 http://www.gnn.com.br/forum/showthread.php?t=1000087592 http://www.gnn.com.br/forum/showthread.php?t=1000087591 http://www.gnn.com.br/forum/showthread.php?t=1000087590 http://www.gnn.com.br/forum/showthread.php?t=1000087588 http://www.gnn.com.br/forum/showthread.php?t=1000087587 http://www.gnn.com.br/forum/showthread.php?t=1000087586 http://www.gnn.com.br/forum/showthread.php?t=1000087585 http://www.gnn.com.br/forum/showthread.php?t=1000087584 http://www.gnn.com.br/forum/showthread.php?t=1000087583 http://www.gnn.com.br/forum/showthread.php?t=1000087582 http://www.gnn.com.br/forum/showthread.php?t=1000087581 http://www.gnn.com.br/forum/showthread.php?t=1000087579 http://www.gnn.com.br/forum/showthread.php?t=1000087578 http://www.gnn.com.br/forum/showthread.php?t=1000087577 http://www.gnn.com.br/forum/showthread.php?t=1000087575 http://www.gnn.com.br/forum/showthread.php?t=1000087574 http://www.gnn.com.br/forum/showthread.php?t=1000087573 http://www.gnn.com.br/forum/showthread.php?t=1000087572 http://www.gnn.com.br/forum/showthread.php?t=1000087571 http://www.gnn.com.br/forum/showthread.php?t=1000087570 http://www.gnn.com.br/forum/showthread.php?t=1000087569 http://www.gnn.com.br/forum/showthread.php?t=1000087568 http://www.gnn.com.br/forum/showthread.php?t=1000087567 http://www.gnn.com.br/forum/showthread.php?t=1000087565 http://www.gnn.com.br/forum/showthread.php?t=1000087564 http://www.gnn.com.br/forum/showthread.php?t=1000087561 http://www.gnn.com.br/forum/showthread.php?t=1000087559 http://www.gnn.com.br/forum/showthread.php?t=1000087558 http://www.gnn.com.br/forum/showthread.php?t=1000087557 http://www.gnn.com.br/forum/showthread.php?t=1000087556 http://www.gnn.com.br/forum/showthread.php?t=1000087555 > Avoid joins on <composite-key><key-many-to-one> queries > ------------------------------------------------------- > > Key: NH-766 > URL: http://jira.nhibernate.org/browse/NH-766 > Project: NHibernate > Issue Type: Improvement > Components: Core > Affects Versions: 1.0.2 > Reporter: Kirk Wylie > Fix For: 2.1.0.Alpha1 > > > This is being promoted from something I posted on the NHibernate forums. > Using NHibernate 1.0.2.0 against Oracle 9. > I'm working with an existing schema which isn't using surrogate keys, and I have a composite key of the form: > <class name="CalculatedRating" ...> > <composite-id> > <key-property name="EffectiveDate" column="EFFECTIVE_DATE"/> > <key-many-to-one name="FdeOrganization" column="ORGANIZATION_ID" .../> > </composite-id> > ... > </class> > Using this query: > from CalculatedRating cr > inner join fetch cr.FdeOrganization fdeOrg > left join fetch fdeOrg.Attributes as attribute > inner join fetch attribute.AttributeType > where cr.EffectiveDate = > (select max(cr2.EffectiveDate) > from CalculatedRating cr2 > where cr2.EffectiveDate >= :EffectiveDate) > order by cr.FdeOrganization.OrgId > NHibernate is quite correctly generating the SQL necessary to completely manifest the CalculatedRating element in a single query. However, after executing that query, it then still proceeds to do the N+1 select on FdeOrganization. > As in this application I'm actually using quite a few cases where I'm successfully using the inner join fetch technique against FdeOrganization, I can only assume that this is a problem related to key-many-to-one rather than many-to-one. > After further investigation, I can establish that Hibernate 3.1.3 exposes the exact same functionality. I'm filing this first against NHibernate since that's where I first discovered it, however, since it affects Hibernate as well it might be better filed against that, and I can do so if needed. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://jira.nhibernate.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
View entire thread
You seem to have CSS turned off. Please don't fill out this field.
Click URL instructions: Right-click on the ad, choose "Copy Link", then paste here → (This may not be possible with some types of ads)
Ad destination/click URL:
