[ http://jira.nhibernate.org/browse/NH-766?page=comments#action_15054 ] kevin armano commented on NH-766: --------------------------------- http://fyad.org/kufj http://fyad.org/kugb http://fyad.org/kugc http://fyad.org/kugd http://fyad.org/kugf http://fyad.org/kuh4 http://fyad.org/kuh5 http://fyad.org/kuh6 http://fyad.org/kuh7 http://fyad.org/kuh8 http://fyad.org/kuh9 http://fyad.org/kuhb http://fyad.org/kuhc http://fyad.org/kuhd http://fyad.org/kuhe http://fyad.org/kuhf http://fyad.org/kuhg http://fyad.org/kuhi http://fyad.org/kuhj http://fyad.org/kuhl http://fyad.org/kuhm http://fyad.org/kuhn http://fyad.org/kuho http://fyad.org/kuhp http://fyad.org/kuhq http://fyad.org/kuhr http://fyad.org/kuht http://fyad.org/kuhu http://fyad.org/kuhv http://fyad.org/kuhw http://fyad.org/kuhx http://fyad.org/kuhy http://fyad.org/kui0 http://fyad.org/kui1 http://fyad.org/kui2 http://fyad.org/kui3 http://fyad.org/kui4 http://fyad.org/kui5 http://fyad.org/kui9 http://fyad.org/kuia http://fyad.org/kuic http://fyad.org/kuid http://fyad.org/kuie http://fyad.org/kuif http://fyad.org/kuig http://fyad.org/kuih http://fyad.org/kuii http://fyad.org/kuij http://fyad.org/kuik http://fyad.org/kuil http://fyad.org/kuim http://fyad.org/kuin http://fyad.org/kuiq http://fyad.org/kuis http://fyad.org/kuit http://fyad.org/kuiu http://fyad.org/kuiw http://fyad.org/kuiy http://fyad.org/kuiz http://fyad.org/kuj0 http://fyad.org/kuj1 http://fyad.org/kuj2 http://fyad.org/kuj3 http://fyad.org/kuj4 http://fyad.org/kuj5 http://fyad.org/kuj6 http://fyad.org/kuj7 http://fyad.org/kuj9 http://fyad.org/kuja http://fyad.org/kujc http://fyad.org/kujd http://fyad.org/kuje http://fyad.org/kujt http://fyad.org/kujv http://fyad.org/kujx http://fyad.org/kujy http://fyad.org/kujz http://fyad.org/kuk1 http://fyad.org/kuk2 http://fyad.org/kuk3 http://fyad.org/kuk4 http://fyad.org/kuk5 http://fyad.org/kuk6 http://fyad.org/kuk7 http://fyad.org/kuk8 http://fyad.org/kuk9 http://fyad.org/kuka http://fyad.org/kukb http://fyad.org/kukc http://fyad.org/kukd http://fyad.org/kuke http://fyad.org/kukf http://fyad.org/kukg http://fyad.org/kukh http://fyad.org/kuki http://fyad.org/kukj http://fyad.org/kukk http://fyad.org/kukl http://fyad.org/kukm http://fyad.org/kukp http://fyad.org/kukr http://fyad.org/kuks http://fyad.org/kukt http://fyad.org/kukv http://fyad.org/kukw http://fyad.org/kukx http://fyad.org/kuky http://fyad.org/kukz http://fyad.org/kul1 http://fyad.org/kul3 http://fyad.org/kul4 http://fyad.org/kul6 http://fyad.org/kul8 http://fyad.org/kul9 http://fyad.org/kula http://fyad.org/kulb http://fyad.org/kulc http://fyad.org/kulf http://fyad.org/kulg http://fyad.org/kulh http://fyad.org/kull http://fyad.org/kulm http://fyad.org/kuln http://fyad.org/kulp http://fyad.org/kulq http://fyad.org/kulr http://fyad.org/kult http://fyad.org/kulv http://fyad.org/kulw http://fyad.org/kulx http://fyad.org/kuly http://fyad.org/kulz http://fyad.org/kum0 http://fyad.org/kum2 http://fyad.org/kum3 http://fyad.org/kum4 http://fyad.org/kum5 http://fyad.org/kuns http://fyad.org/kunt http://fyad.org/kunu http://fyad.org/kunv http://fyad.org/kunx http://fyad.org/kuo0 http://fyad.org/kuo2 http://fyad.org/kuo3 http://fyad.org/kuo4 http://fyad.org/kuo5 http://fyad.org/kuo7 http://fyad.org/kuo8 http://fyad.org/kuo9 http://fyad.org/kuoa http://fyad.org/kuob http://fyad.org/kuoc http://fyad.org/kuod http://fyad.org/kuof http://fyad.org/kuog http://fyad.org/kuoh http://fyad.org/kuoi http://fyad.org/kuoj http://fyad.org/kuok http://fyad.org/kuon http://fyad.org/kuoo http://fyad.org/kuoq http://fyad.org/kuor http://fyad.org/kuos http://fyad.org/kuot http://fyad.org/kuou http://fyad.org/kuow http://fyad.org/kuoy http://fyad.org/kuoz http://fyad.org/kup0 http://fyad.org/kup2 http://fyad.org/kup3 http://fyad.org/kup4 http://fyad.org/kup5 http://fyad.org/kup6 http://fyad.org/kup7 http://fyad.org/kup9 http://fyad.org/kupc http://fyad.org/kupd http://fyad.org/kupf http://fyad.org/kupg http://fyad.org/kupi http://fyad.org/kupj http://fyad.org/kupm http://fyad.org/kupn http://fyad.org/kupp http://fyad.org/kupr http://fyad.org/kups http://fyad.org/kupt http://fyad.org/kupu http://fyad.org/kupv http://fyad.org/kupw http://fyad.org/kupx http://fyad.org/kupy http://fyad.org/kupz http://fyad.org/kuq0 http://fyad.org/kuq1 http://fyad.org/kuq3 http://fyad.org/kuq4 http://fyad.org/kuq5 http://fyad.org/kuq6 http://fyad.org/kuq7 http://fyad.org/kuq8 http://fyad.org/kuq9 http://fyad.org/kuqa http://fyad.org/kuqc http://fyad.org/kuqd http://fyad.org/kuqf http://fyad.org/kuqg http://fyad.org/kutd http://fyad.org/kute http://fyad.org/kutf http://fyad.org/kuth http://fyad.org/kuti http://fyad.org/kutj http://fyad.org/kutm http://fyad.org/kutn http://fyad.org/kuto http://fyad.org/kutq http://fyad.org/kutr http://fyad.org/kutt http://fyad.org/kutu http://fyad.org/kutv http://fyad.org/kutx http://fyad.org/kuty http://fyad.org/kutz http://fyad.org/kuu0 http://fyad.org/kuu2 http://fyad.org/kuu3 http://fyad.org/kuu4 http://fyad.org/kuu5 http://fyad.org/kuu8 http://fyad.org/kuua http://fyad.org/kuub http://fyad.org/kuud http://fyad.org/kuue http://fyad.org/kuuf http://fyad.org/kuug http://fyad.org/kuui http://fyad.org/kuuj http://fyad.org/kuul http://fyad.org/kuum http://fyad.org/kuuo http://fyad.org/kuup http://fyad.org/kuuq http://fyad.org/kuur http://fyad.org/kuus http://fyad.org/kuut http://fyad.org/kuuu http://fyad.org/kuuv http://fyad.org/kuuw http://fyad.org/kuuy http://fyad.org/kuuz http://fyad.org/kuv0 http://fyad.org/kuv1 http://fyad.org/kuv2 http://fyad.org/kuv3 http://fyad.org/kuv4 http://fyad.org/kuv5 http://fyad.org/kuv6 http://fyad.org/kuv7 http://fyad.org/kuv9 http://fyad.org/kuvb http://fyad.org/kuvc http://fyad.org/kuve http://fyad.org/kuvg http://fyad.org/kuvh http://fyad.org/kuvj http://fyad.org/kuvk http://fyad.org/kuvl http://fyad.org/kuvm http://fyad.org/kuvn http://fyad.org/kuvo http://fyad.org/kuvp http://fyad.org/kuvq http://fyad.org/kuvr http://fyad.org/kuvs http://fyad.org/kuvv http://fyad.org/kuvw http://fyad.org/kuvx http://fyad.org/kuvy http://fyad.org/kuvz http://fyad.org/kuw1 http://fyad.org/kuw2 http://fyad.org/kuw5 http://fyad.org/kuw7 http://fyad.org/kuw8 http://fyad.org/kuw9 http://fyad.org/kuwa http://fyad.org/kuwb http://fyad.org/kuwc http://fyad.org/kuwd http://fyad.org/kuwf http://fyad.org/kuwg http://fyad.org/kuwh http://fyad.org/kuwj http://fyad.org/kuwk http://fyad.org/kuwl http://fyad.org/kuwn http://fyad.org/kuwo http://fyad.org/kuwp http://fyad.org/kuwq http://fyad.org/kuws http://fyad.org/kuwt http://fyad.org/kuwu http://fyad.org/kuwv http://fyad.org/kuwx http://fyad.org/kuwy http://fyad.org/kux0 http://fyad.org/kux1 http://fyad.org/kux2 http://fyad.org/kux4 http://fyad.org/kux5 http://fyad.org/kux6 http://fyad.org/kux8 http://fyad.org/kux9 http://fyad.org/kuxa http://fyad.org/kuxb http://fyad.org/kuxc http://fyad.org/kuxd http://fyad.org/kuxf > 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:
