[ http://jira.nhibernate.org/browse/NH-766?page=comments#action_15042 ] ioo noao commented on NH-766: ----------------------------- http://www.6URL.com/1566 http://www.6URL.com/1567 http://www.6URL.com/1568 http://www.6URL.com/1569 http://www.6URL.com/156A http://www.6URL.com/156B http://www.6URL.com/156C http://www.6URL.com/156D http://www.6URL.com/156E http://www.6URL.com/156F http://www.6URL.com/156G http://www.6URL.com/156H http://www.6URL.com/156I http://www.6URL.com/156J http://www.6URL.com/156K http://www.6URL.com/156L http://www.6URL.com/156M http://www.6URL.com/156N http://www.6URL.com/156O http://www.6URL.com/156P http://www.6URL.com/156Q http://www.6URL.com/156R http://www.6URL.com/156S http://www.6URL.com/156T http://www.6URL.com/156U http://www.6URL.com/156V http://www.6URL.com/156W http://www.6URL.com/156X http://www.6URL.com/156Y http://www.6URL.com/156Z http://www.6URL.com/1570 http://www.6URL.com/1571 http://www.6URL.com/1572 http://www.6URL.com/1573 http://www.6URL.com/1574 http://www.6URL.com/1575 http://www.6URL.com/1576 http://www.6URL.com/1577 http://www.6URL.com/1578 http://www.6URL.com/1579 http://www.6URL.com/157A http://www.6URL.com/157B http://www.6URL.com/157C http://www.6URL.com/157D http://www.6URL.com/157E http://www.6URL.com/157F http://www.6URL.com/157G http://www.6URL.com/157H http://www.6URL.com/157I http://www.6URL.com/157J http://www.6URL.com/157K http://www.6URL.com/157L http://www.6URL.com/157M http://www.6URL.com/157S http://www.6URL.com/157T http://www.6URL.com/157V http://www.6URL.com/157W http://www.6URL.com/157X http://www.6URL.com/157Y http://www.6URL.com/157Z http://www.6URL.com/1580 http://www.6URL.com/1581 http://www.6URL.com/1582 http://www.6URL.com/1583 http://www.6URL.com/1584 http://www.6URL.com/1585 http://www.6URL.com/1586 http://www.6URL.com/1587 http://www.6URL.com/1588 http://www.6URL.com/1589 http://www.6URL.com/158A http://www.6URL.com/158B http://www.6URL.com/158C http://www.6URL.com/158D http://www.6URL.com/158E http://www.6URL.com/158G http://www.6URL.com/158H http://www.6URL.com/158I http://www.6URL.com/158J http://www.6URL.com/158K http://www.6URL.com/158L http://www.6URL.com/158M http://www.6URL.com/158N http://www.6URL.com/158O http://www.6URL.com/158P http://www.6URL.com/158Q http://www.6URL.com/158R http://www.6URL.com/158S http://www.6URL.com/158T http://www.6URL.com/158U http://www.6URL.com/158V http://www.6URL.com/158W http://www.6URL.com/158X http://www.6URL.com/158Y http://www.6URL.com/158Z http://www.6URL.com/1590 http://www.6URL.com/1591 http://www.6URL.com/1592 http://www.6URL.com/1593 http://www.6URL.com/1594 http://www.6URL.com/1595 http://www.6URL.com/1596 http://www.6URL.com/1597 http://www.6URL.com/1598 http://www.6URL.com/1599 http://www.6URL.com/159A http://www.6URL.com/159B http://www.6URL.com/159C http://www.6URL.com/159D http://www.6URL.com/159E http://www.6URL.com/159F http://www.6URL.com/159G http://www.6URL.com/159H http://www.6URL.com/159I http://www.6URL.com/159J http://www.6URL.com/159K http://www.6URL.com/159L http://www.6URL.com/159M http://www.6URL.com/159N http://www.6URL.com/159O http://www.6URL.com/159P http://www.6URL.com/159Q http://www.6URL.com/159R http://www.6URL.com/159S http://www.6URL.com/159T http://www.6URL.com/159U http://www.6URL.com/159V http://www.6URL.com/159W http://www.6URL.com/159X http://www.6URL.com/159Y http://www.6URL.com/159Z http://www.6URL.com/15A0 http://www.6URL.com/15A1 http://www.6URL.com/15A2 http://www.6URL.com/15A3 http://www.6URL.com/15A4 http://www.6URL.com/15A5 http://www.6URL.com/15A6 http://www.6URL.com/15A7 http://www.6URL.com/15A8 http://www.6URL.com/15A9 http://www.6URL.com/15AA http://www.6URL.com/15AB http://www.6URL.com/15AC http://www.6URL.com/15AD http://www.6URL.com/15AE http://www.6URL.com/15AF http://www.6URL.com/15AG http://www.6URL.com/15AH http://www.6URL.com/15AI http://www.6URL.com/15AJ http://www.6URL.com/15AK http://www.6URL.com/15AL http://www.6URL.com/15AM http://www.6URL.com/15AN http://www.6URL.com/15AO http://www.6URL.com/15AP http://www.6URL.com/15AQ http://www.6URL.com/15AR http://www.6URL.com/15AS http://www.6URL.com/15AT http://www.6URL.com/15AU http://www.6URL.com/15AV http://www.6URL.com/15AX http://www.6URL.com/15AZ http://www.6URL.com/15B0 http://www.6URL.com/15B1 http://www.6URL.com/15B2 http://www.6URL.com/15B3 http://www.6URL.com/15B4 http://www.6URL.com/15B5 http://www.6URL.com/15B6 http://www.6URL.com/15B7 http://www.6URL.com/15B8 http://www.6URL.com/15B9 http://www.6URL.com/15BA http://www.6URL.com/15BB http://www.6URL.com/15BC http://www.6URL.com/15BD http://www.6URL.com/15BE http://www.6URL.com/15BF http://www.6URL.com/15BG http://www.6URL.com/15BH http://www.6URL.com/15BI http://www.6URL.com/15BJ http://www.6URL.com/15BK http://www.6URL.com/15BL http://www.6URL.com/15BM http://www.6URL.com/15BN http://www.6URL.com/15BO http://www.6URL.com/15BP http://www.6URL.com/15BQ http://www.6URL.com/15BR http://www.6URL.com/15BS http://www.6URL.com/15BT http://www.6URL.com/15BU http://www.6URL.com/15BV http://www.6URL.com/15BW http://www.6URL.com/15BX http://www.6URL.com/15BY http://www.6URL.com/15BZ http://www.6URL.com/15C0 http://www.6URL.com/15C1 http://www.6URL.com/15C2 http://www.6URL.com/15C3 http://www.6URL.com/15C4 http://www.6URL.com/15C5 http://www.6URL.com/15C6 http://www.6URL.com/15C7 http://www.6URL.com/15C8 http://www.6URL.com/15C9 http://www.6URL.com/15CA http://www.6URL.com/15CB http://www.6URL.com/15CC http://www.6URL.com/15CD http://www.6URL.com/15CE http://www.6URL.com/15CF http://www.6URL.com/15CG http://www.6URL.com/15CH http://www.6URL.com/15CI http://www.6URL.com/15CJ http://www.6URL.com/15CK http://www.6URL.com/15CL http://www.6URL.com/15CM http://www.6URL.com/15CN http://www.6URL.com/15CO http://www.6URL.com/15CP http://www.6URL.com/15CQ http://www.6URL.com/15CR http://www.6URL.com/15CS http://www.6URL.com/15CT http://www.6URL.com/15CU http://kuso.cc/1g5f http://kuso.cc/1g5g http://kuso.cc/1g5h http://kuso.cc/1g5i http://kuso.cc/1g5j http://kuso.cc/1g5k http://kuso.cc/1g5l http://kuso.cc/1g5m http://kuso.cc/1g5n http://kuso.cc/1g5o http://kuso.cc/1g5p http://kuso.cc/1g5q http://kuso.cc/1g5r http://kuso.cc/1g5s http://kuso.cc/1g5t http://kuso.cc/1g5u http://kuso.cc/1g5v http://kuso.cc/1g5w http://kuso.cc/1g5x http://kuso.cc/1g5y http://kuso.cc/1g5z http://kuso.cc/1g5A http://kuso.cc/1g5B http://kuso.cc/1g5C > Avoid joins on <composite-key><key-many-to-one> queries > ------------------------------------------------------- > > Key: NH-766 > URL: http://jira.nhibernate.org/browse/NH-766 > Project: NHibernate > Type: Improvement > Components: Core > Versions: 1.0.2 > Reporter: Kirk Wylie > Priority: Trivial > Fix For: LATER > > 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:
