I have a mapping like this:
public ProjectPlanningMap()
{
Table("Planning");
Id(planning => planning.ID,
"Planning_ID").GeneratedBy.Native();
Map(planning => planning.FMEA);
Map(planning => planning.InitialDate);
Map(planning => planning.NeedsResearch);
Map(planning => planning.QAApprovalDone,
"TeamQAApprovalDone");
References(planning => planning._rx, "RX_ID").LazyLoad();
References(planning => planning.Type,
"Type_ID").LazyLoad();
References(planning => planning.StatusPlanning,
"StatusPlanning_ID").LazyLoad().Nullable();
Map(planning => planning.CancelledReason);
Map(planning => planning.CancelledDate);
// costs
Map(planning => planning.TargetSRP_EUR);
Map(planning => planning.TargetSRP_USD);
Map(planning => planning.CparSRP_EUR);
Map(planning => planning.CparSRP_USD);
Map(planning => planning.CparCostYear);
Map(planning => planning.CPARApproval);
// Forecasts
Map(planning => planning.Forecast1Year);
Map(planning => planning.Forecast2Year);
Map(planning => planning.Forecast3Year);
Map(planning => planning.Forecast4Year);
Map(planning => planning.ForecastPhoto);
References(planning => planning.ForecastPhotoFile,
"ForecastPhotoFile_ID").LazyLoad();
// resources
References(planning => planning.CAD,
"CAD_ID").LazyLoad().Nullable();
References(planning => planning.ENG,
"ENG_ID").LazyLoad().Nullable();
References(planning => planning.ProductManager,
"ProductManager_ID").LazyLoad().Nullable();
References(planning => planning.PurMgr,
"PurchasingManager_ID").LazyLoad().Nullable();
References(planning => planning.Design1,
"ProdDesign1_ID").LazyLoad().Nullable();
References(planning => planning.Design2,
"ProdDesign2_ID").LazyLoad().Nullable();
References(planning => planning.QA,
"QAResponsible").LazyLoad().Nullable();
References(planning => planning.RD,
"RandDEngineer_ID").LazyLoad().Nullable();
References(planning => planning.Industry,
"Industry_ID").LazyLoad().Nullable();
// Marketing Milestones
HasOne(planning =>
planning.MarketingMilestone).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
// Milestones
HasOne(planning => planning.MilestoneInHouse).PropertyRef(m
=> m.ProjectPlanning).Cascade.All();
HasOne(planning => planning.MilestoneHybrid).PropertyRef(m
=> m.ProjectPlanning).Cascade.All();
HasOne(planning =>
planning.MilestoneTestMoldIncluded).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasOne(planning =>
planning.MilestoneLicensingPrinting).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasOne(planning => planning.MilestonePickUp).PropertyRef(m
=> m.ProjectPlanning).Cascade.All();
HasOne(planning =>
planning.MilestonePrinting).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasOne(planning => planning.MilestoneTPS).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasOne(planning =>
planning.MilestoneTpsPrinting).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasOne(planning => planning.MilestoneTTrends).PropertyRef(m
=> m.ProjectPlanning).Cascade.All();
HasOne(planning =>
planning.MilestoneConsumables).PropertyRef(m =>
m.ProjectPlanning).Cascade.All();
HasMany(planning =>
planning.MilestoneInHousePlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneHybridPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneInhouseTestMoldIncludedPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneTPSPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneConsumablesPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneLicensingPrintingPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestonePickupPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestonePrintingPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneTPSPrintingPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.MilestoneTTrendsPlannedList).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning.SubProducts).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
HasMany(planning =>
planning._comments).KeyColumn("Planning_ID").Cascade.All().LazyLoad();
Map(e => e.CreatedDate);
Map(e => e.ModifiedDate);
References(c => c.CreatedBy, "CreatedBy").LazyLoad();
References(c => c.ModifiedBy, "ModifiedBy").LazyLoad();
}
My problem lies in the milestones. I cant lazyload() the HasOne-
relationships...causing the queries that nhibernate generates to be
inefficient and big. You see, he outerjoins all the milestone tables
and a query looks like this:
exec sp_executesql N'SELECT projectpla0_.Planning_ID as
Planning1_74_11_, projectpla0_.FMEA as FMEA74_11_,
projectpla0_.InitialDate as InitialD3_74_11_,
projectpla0_.NeedsResearch as NeedsRes4_74_11_,
projectpla0_.TeamQAApprovalDone as TeamQAAp5_74_11_,
projectpla0_.CancelledReason as Cancelle6_74_11_,
projectpla0_.CancelledDate as Cancelle7_74_11_,
projectpla0_.TargetSRP_EUR as TargetSRP8_74_11_,
projectpla0_.TargetSRP_USD as TargetSRP9_74_11_,
projectpla0_.CparSRP_EUR as CparSRP10_74_11_, projectpla0_.CparSRP_USD
as CparSRP11_74_11_, projectpla0_.CparCostYear as CparCos12_74_11_,
projectpla0_.CPARApproval as CPARApp13_74_11_,
projectpla0_.Forecast1Year as Forecast14_74_11_,
projectpla0_.Forecast2Year as Forecast15_74_11_,
projectpla0_.Forecast3Year as Forecast16_74_11_,
projectpla0_.Forecast4Year as Forecast17_74_11_,
projectpla0_.ForecastPhoto as Forecas18_74_11_,
projectpla0_.CreatedDate as Created19_74_11_,
projectpla0_.ModifiedDate as Modifie20_74_11_, projectpla0_.RX_ID as
RX21_74_11_, projectpla0_.Type_ID as Type22_74_11_,
projectpla0_.StatusPlanning_ID as StatusP23_74_11_,
projectpla0_.ForecastPhotoFile_ID as Forecas24_74_11_,
projectpla0_.CAD_ID as CAD25_74_11_, projectpla0_.ENG_ID as
ENG26_74_11_, projectpla0_.ProductManager_ID as Product27_74_11_,
projectpla0_.PurchasingManager_ID as Purchas28_74_11_,
projectpla0_.ProdDesign1_ID as ProdDesign29_74_11_,
projectpla0_.ProdDesign2_ID as ProdDesign30_74_11_,
projectpla0_.QAResponsible as QARespo31_74_11_,
projectpla0_.RandDEngineer_ID as RandDEn32_74_11_,
projectpla0_.Industry_ID as Industry33_74_11_, projectpla0_.CreatedBy
as CreatedBy74_11_, projectpla0_.ModifiedBy as ModifiedBy74_11_,
marketingm1_.PlanningMarketingMilestone_ID as Planning1_67_0_,
marketingm1_.StartProductBrief as StartPro2_67_0_,
marketingm1_.SendProductBrief as SendProd3_67_0_,
marketingm1_.OrganiseKickOff as Organise4_67_0_,
marketingm1_.StartInitialForecast as StartIni5_67_0_,
marketingm1_.NPAissue as NPAissue67_0_, marketingm1_.ColorBrief as
ColorBrief67_0_, marketingm1_.CommColorsToMoldEng as CommColo8_67_0_,
marketingm1_.FinalColorEmail as FinalCol9_67_0_,
marketingm1_.StartLeaflet as StartLe10_67_0_,
marketingm1_.StartLaunchMaterial as StartLa11_67_0_,
marketingm1_.SendLaunchMaterial as SendLau12_67_0_,
marketingm1_.StartProductBriefRealised as StartPr13_67_0_,
marketingm1_.SendProductBriefRealised as SendPro14_67_0_,
marketingm1_.OrganiseKickOffRealised as Organis15_67_0_,
marketingm1_.StartInitialForecastRealised as StartIn16_67_0_,
marketingm1_.NPAissueRealised as NPAissu17_67_0_,
marketingm1_.ColorBriefRealised as ColorBr18_67_0_,
marketingm1_.CommColorsToMoldEngRealised as CommCol19_67_0_,
marketingm1_.FinalColorEmailRealised as FinalCo20_67_0_,
marketingm1_.StartLeafletRealised as StartLe21_67_0_,
marketingm1_.StartLaunchMaterialRealised as StartLa22_67_0_,
marketingm1_.SendLaunchMaterialRealised as SendLau23_67_0_,
marketingm1_.CreatedDate as Created24_67_0_, marketingm1_.ModifiedDate
as Modifie25_67_0_, marketingm1_.Planning_ID as Planning26_67_0_,
marketingm1_.CreatedBy as CreatedBy67_0_, marketingm1_.ModifiedBy as
ModifiedBy67_0_, milestonei2_.PlanningGeneral_ID as Planning1_75_1_,
milestonei2_.MAD_Initial as MAD2_75_1_, milestonei2_.TAD_Initial as
TAD3_75_1_, milestonei2_.PBissue_Initial as PBissue4_75_1_,
milestonei2_.PBapproval_Initial as PBapproval5_75_1_,
milestonei2_.KickOfMeeting_Initial as KickOfMe6_75_1_,
milestonei2_.DesignConcept_Initial as DesignCo7_75_1_,
milestonei2_.FinalDesign_Initial as FinalDes8_75_1_,
milestonei2_.CadCanStart_Initial as CadCanSt9_75_1_,
milestonei2_.PrelCAD_Initial as PrelCAD10_75_1_,
milestonei2_.FinalCAD_Initial as FinalCAD11_75_1_,
milestonei2_.NPAIssue_Initial as NPAIssue12_75_1_,
milestonei2_.PrelSpec_Initial as PrelSpec13_75_1_,
milestonei2_.MoldOrder_Initial as MoldOrder14_75_1_,
milestonei2_.MoldDelivery_Initial as MoldDel15_75_1_,
milestonei2_.ConceptGoNoGo_Initial as Concept16_75_1_,
milestonei2_.FinalSpec_Initial as FinalSpec17_75_1_,
milestonei2_.MAD_Realised as MAD18_75_1_, milestonei2_.TAD_Realised as
TAD19_75_1_, milestonei2_.PBissue_Realised as PBissue20_75_1_,
milestonei2_.PBapproval_Realised as PBapproval21_75_1_,
milestonei2_.KickOfMeeting_Realised as KickOfM22_75_1_,
milestonei2_.DesignConcept_Realised as DesignC23_75_1_,
milestonei2_.FinalDesign_Realised as FinalDe24_75_1_,
milestonei2_.CadCanStart_Realised as CadCanS25_75_1_,
milestonei2_.PrelCAD_Realised as PrelCAD26_75_1_,
milestonei2_.FinalCAD_Realised as FinalCAD27_75_1_,
milestonei2_.NPAIssue_Realised as NPAIssue28_75_1_,
milestonei2_.PrelSpec_Realised as PrelSpec29_75_1_,
milestonei2_.MoldOrder_Realised as MoldOrder30_75_1_,
milestonei2_.MoldDelivery_Realised as MoldDel31_75_1_,
milestonei2_.ConceptGoNoGo_Realised as Concept32_75_1_,
milestonei2_.FinalSpec_Realised as FinalSpec33_75_1_,
milestonei2_.CreatedDate as Created34_75_1_, milestonei2_.ModifiedDate
as Modifie35_75_1_, milestonei2_.Planning_ID as Planning36_75_1_,
milestonei2_.CreatedBy as CreatedBy75_1_, milestonei2_.ModifiedBy as
ModifiedBy75_1_, milestoneh3_.PlanningHybrid_ID as Planning1_60_2_,
milestoneh3_.MAD_Initial as MAD2_60_2_, milestoneh3_.TAD_Initial as
TAD3_60_2_, milestoneh3_.PBissue_Initial as PBissue4_60_2_,
milestoneh3_.PBapproval_Initial as PBapproval5_60_2_,
milestoneh3_.KickOfMeeting_Initial as KickOfMe6_60_2_,
milestoneh3_.DesignConcept_Initial as DesignCo7_60_2_,
milestoneh3_.FinalDesign_Initial as FinalDes8_60_2_,
milestoneh3_.CadCanStart_Initial as CadCanSt9_60_2_,
milestoneh3_.PrelCAD_Initial as PrelCAD10_60_2_,
milestoneh3_.FinalCAD_Initial as FinalCAD11_60_2_,
milestoneh3_.NPAIssue_Initial as NPAIssue12_60_2_,
milestoneh3_.PrelSpec_Initial as PrelSpec13_60_2_,
milestoneh3_.MoldOrder_Initial as MoldOrder14_60_2_,
milestoneh3_.MoldDelivery_Initial as MoldDel15_60_2_,
milestoneh3_.ConceptGoNoGo_Initial as Concept16_60_2_,
milestoneh3_.FinalSpec_Initial as FinalSpec17_60_2_,
milestoneh3_.MAD_Realised as MAD18_60_2_, milestoneh3_.TAD_Realised as
TAD19_60_2_, milestoneh3_.PBissue_Realised as PBissue20_60_2_,
milestoneh3_.PBapproval_Realised as PBapproval21_60_2_,
milestoneh3_.KickOfMeeting_Realised as KickOfM22_60_2_,
milestoneh3_.DesignConcept_Realised as DesignC23_60_2_,
milestoneh3_.FinalDesign_Realised as FinalDe24_60_2_,
milestoneh3_.CadCanStart_Realised as CadCanS25_60_2_,
milestoneh3_.PrelCAD_Realised as PrelCAD26_60_2_,
milestoneh3_.FinalCAD_Realised as FinalCAD27_60_2_,
milestoneh3_.NPAIssue_Realised as NPAIssue28_60_2_,
milestoneh3_.PrelSpec_Realised as PrelSpec29_60_2_,
milestoneh3_.MoldOrder_Realised as MoldOrder30_60_2_,
milestoneh3_.MoldDelivery_Realised as MoldDel31_60_2_,
milestoneh3_.ConceptGoNoGo_Realised as Concept32_60_2_,
milestoneh3_.FinalSpec_Realised as FinalSpec33_60_2_,
milestoneh3_.CreatedDate as Created34_60_2_, milestoneh3_.ModifiedDate
as Modifie35_60_2_, milestoneh3_.Planning_ID as Planning36_60_2_,
milestoneh3_.CreatedBy as CreatedBy60_2_, milestoneh3_.ModifiedBy as
ModifiedBy60_2_, milestonei4_.PlanningInHouseTestMoldIncluded_ID as
Planning1_79_3_, milestonei4_.MAD_Initial as MAD2_79_3_,
milestonei4_.TAD_Initial as TAD3_79_3_, milestonei4_.PBissue_Initial
as PBissue4_79_3_, milestonei4_.PBapproval_Initial as
PBapproval5_79_3_, milestonei4_.KickOfMeeting_Initial as
KickOfMe6_79_3_, milestonei4_.DesignConcept_Initial as
DesignCo7_79_3_, milestonei4_.FinalDesign_Initial as FinalDes8_79_3_,
milestonei4_.CadCanStart_Initial as CadCanSt9_79_3_,
milestonei4_.PrelCAD_Initial as PrelCAD10_79_3_,
milestonei4_.FinalCAD_Initial as FinalCAD11_79_3_,
milestonei4_.NPAIssue_Initial as NPAIssue12_79_3_,
milestonei4_.PrelSpec_Initial as PrelSpec13_79_3_,
milestonei4_.MoldOrder_Initial as MoldOrder14_79_3_,
milestonei4_.MoldDelivery_Initial as MoldDel15_79_3_,
milestonei4_.ConceptGoNoGo_Initial as Concept16_79_3_,
milestonei4_.FinalSpec_Initial as FinalSpec17_79_3_,
milestonei4_.MAD_Realised as MAD18_79_3_, milestonei4_.TAD_Realised as
TAD19_79_3_, milestonei4_.PBissue_Realised as PBissue20_79_3_,
milestonei4_.PBapproval_Realised as PBapproval21_79_3_,
milestonei4_.KickOfMeeting_Realised as KickOfM22_79_3_,
milestonei4_.DesignConcept_Realised as DesignC23_79_3_,
milestonei4_.FinalDesign_Realised as FinalDe24_79_3_,
milestonei4_.CadCanStart_Realised as CadCanS25_79_3_,
milestonei4_.PrelCAD_Realised as PrelCAD26_79_3_,
milestonei4_.FinalCAD_Realised as FinalCAD27_79_3_,
milestonei4_.NPAIssue_Realised as NPAIssue28_79_3_,
milestonei4_.PrelSpec_Realised as PrelSpec29_79_3_,
milestonei4_.MoldOrder_Realised as MoldOrder30_79_3_,
milestonei4_.MoldDelivery_Realised as MoldDel31_79_3_,
milestonei4_.ConceptGoNoGo_Realised as Concept32_79_3_,
milestonei4_.FinalSpec_Realised as FinalSpec33_79_3_,
milestonei4_.CreatedDate as Created34_79_3_, milestonei4_.ModifiedDate
as Modifie35_79_3_, milestonei4_.Planning_ID as Planning36_79_3_,
milestonei4_.CreatedBy as CreatedBy79_3_, milestonei4_.ModifiedBy as
ModifiedBy79_3_, milestonel5_.PlanningLicensingPrinting_ID as
Planning1_95_4_, milestonel5_.ApprovalLicensor_Initial as
Approval2_95_4_, milestonel5_.ArtworkApprovalMarkets_Initial as
ArtworkA3_95_4_, milestonel5_.ArtworkDesignAv_Initial as
ArtworkD4_95_4_, milestonel5_.ColorSamplePP_Initial as
ColorSam5_95_4_, milestonel5_.CostDue_Initial as CostDue6_95_4_,
milestonel5_.KickOfMeeting_Initial as KickOfMe7_95_4_,
milestonel5_.OrderLabels_Initial as OrderLab8_95_4_,
milestonel5_.PhotographySample_Initial as Photogra9_95_4_,
milestonel5_.PRBrief_Initial as PRBrief10_95_4_,
milestonel5_.PRSReqForecastDue_Initial as PRSReqF11_95_4_,
milestonel5_.SampleAppLicensor_Initial as SampleA12_95_4_,
milestonel5_.MAD_Initial as MAD13_95_4_, milestonel5_.TAD_Initial as
TAD14_95_4_, milestonel5_.ApprovalLicensor_Realised as
Approva15_95_4_, milestonel5_.ArtworkApprovalMarkets_Realised as
Artwork16_95_4_, milestonel5_.ArtworkDesignAv_Realised as
Artwork17_95_4_, milestonel5_.ColorSamplePP_Realised as
ColorSa18_95_4_, milestonel5_.CostDue_Realised as CostDue19_95_4_,
milestonel5_.KickOfMeeting_Realised as KickOfM20_95_4_,
milestonel5_.OrderLabels_Realised as OrderLa21_95_4_,
milestonel5_.PhotographySample_Realised as Photogr22_95_4_,
milestonel5_.PRBrief_Realised as PRBrief23_95_4_,
milestonel5_.PRSReqForecastDue_Realised as PRSReqF24_95_4_,
milestonel5_.SampleAppLicensor_Realised as SampleA25_95_4_,
milestonel5_.MAD_Realised as MAD26_95_4_, milestonel5_.TAD_Realised as
TAD27_95_4_, milestonel5_.CostBasedOnQuantity_USD as CostBas28_95_4_,
milestonel5_.CostBasedOnQuantity_EUR as CostBas29_95_4_,
milestonel5_.NrOfColors as NrOfColors95_4_,
milestonel5_.PrintingCompanyName as Printin31_95_4_,
milestonel5_.PrintingTechnique as Printin32_95_4_,
milestonel5_.CreatedDate as Created33_95_4_, milestonel5_.ModifiedDate
as Modifie34_95_4_, milestonel5_.Planning_ID as Planning35_95_4_,
milestonel5_.CreatedBy as CreatedBy95_4_, milestonel5_.ModifiedBy as
ModifiedBy95_4_, milestonep6_.PlanningPickUp_ID as Planning1_54_5_,
milestonep6_.MAD_Initial as MAD2_54_5_, milestonep6_.TAD_Initial as
TAD3_54_5_, milestonep6_.MAD_Realised as MAD4_54_5_,
milestonep6_.TAD_Realised as TAD5_54_5_, milestonep6_.CreatedDate as
CreatedD6_54_5_, milestonep6_.ModifiedDate as Modified7_54_5_,
milestonep6_.Planning_ID as Planning8_54_5_, milestonep6_.PickUpRX_ID
as PickUpRX9_54_5_, milestonep6_.CreatedBy as CreatedBy54_5_,
milestonep6_.ModifiedBy as ModifiedBy54_5_,
milestonep7_.PlanningPrinting_ID as Planning1_63_6_,
milestonep7_.ApprovalLicensor_Initial as Approval2_63_6_,
milestonep7_.ArtworkApprovalMarkets_Initial as ArtworkA3_63_6_,
milestonep7_.ArtworkDesignAv_Initial as ArtworkD4_63_6_,
milestonep7_.ColorSamplePP_Initial as ColorSam5_63_6_,
milestonep7_.CostDue_Initial as CostDue6_63_6_,
milestonep7_.KickOfMeeting_Initial as KickOfMe7_63_6_,
milestonep7_.OrderLabels_Initial as OrderLab8_63_6_,
milestonep7_.PhotographySample_Initial as Photogra9_63_6_,
milestonep7_.PRBrief_Initial as PRBrief10_63_6_,
milestonep7_.PRSReqForecastDue_Initial as PRSReqF11_63_6_,
milestonep7_.SampleAppLicensor_Initial as SampleA12_63_6_,
milestonep7_.MAD_Initial as MAD13_63_6_, milestonep7_.TAD_Initial as
TAD14_63_6_, milestonep7_.ApprovalLicensor_Realised as
Approva15_63_6_, milestonep7_.ArtworkApprovalMarkets_Realised as
Artwork16_63_6_, milestonep7_.ArtworkDesignAv_Realised as
Artwork17_63_6_, milestonep7_.ColorSamplePP_Realised as
ColorSa18_63_6_, milestonep7_.CostDue_Realised as CostDue19_63_6_,
milestonep7_.KickOfMeeting_Realised as KickOfM20_63_6_,
milestonep7_.OrderLabels_Realised as OrderLa21_63_6_,
milestonep7_.PhotographySample_Realised as Photogr22_63_6_,
milestonep7_.PRBrief_Realised as PRBrief23_63_6_,
milestonep7_.PRSReqForecastDue_Realised as PRSReqF24_63_6_,
milestonep7_.SampleAppLicensor_Realised as SampleA25_63_6_,
milestonep7_.MAD_Realised as MAD26_63_6_, milestonep7_.TAD_Realised as
TAD27_63_6_, milestonep7_.CostBasedOnQuantity_USD as CostBas28_63_6_,
milestonep7_.CostBasedOnQuantity_EUR as CostBas29_63_6_,
milestonep7_.NrOfColors as NrOfColors63_6_,
milestonep7_.PrintingCompanyName as Printin31_63_6_,
milestonep7_.PrintingTechnique as Printin32_63_6_,
milestonep7_.CreatedDate as Created33_63_6_, milestonep7_.ModifiedDate
as Modifie34_63_6_, milestonep7_.Planning_ID as Planning35_63_6_,
milestonep7_.CreatedBy as CreatedBy63_6_, milestonep7_.ModifiedBy as
ModifiedBy63_6_, milestonet8_.PlanningTPS_ID as Planning1_8_7_,
milestonet8_.MAD_Initial as MAD2_8_7_, milestonet8_.TAD_Initial as
TAD3_8_7_, milestonet8_.PBissue_Initial as PBissue4_8_7_,
milestonet8_.PBapproval_Initial as PBapproval5_8_7_,
milestonet8_.KickOfMeeting_Initial as KickOfMe6_8_7_,
milestonet8_.DesignConcept_Initial as DesignCo7_8_7_,
milestonet8_.FinalDesign_Initial as FinalDes8_8_7_,
milestonet8_.CadCanStart_Initial as CadCanSt9_8_7_,
milestonet8_.PrelCAD_Initial as PrelCAD10_8_7_,
milestonet8_.FinalCAD_Initial as FinalCAD11_8_7_,
milestonet8_.NPAIssue_Initial as NPAIssue12_8_7_,
milestonet8_.PrelSpec_Initial as PrelSpec13_8_7_,
milestonet8_.MoldOrder_Initial as MoldOrder14_8_7_,
milestonet8_.MoldDelivery_Initial as MoldDel15_8_7_,
milestonet8_.ConceptGoNoGo_Initial as Concept16_8_7_,
milestonet8_.FinalSpec_Initial as FinalSpec17_8_7_,
milestonet8_.MAD_Realised as MAD18_8_7_, milestonet8_.TAD_Realised as
TAD19_8_7_, milestonet8_.PBissue_Realised as PBissue20_8_7_,
milestonet8_.PBapproval_Realised as PBapproval21_8_7_,
milestonet8_.KickOfMeeting_Realised as KickOfM22_8_7_,
milestonet8_.DesignConcept_Realised as DesignC23_8_7_,
milestonet8_.FinalDesign_Realised as FinalDe24_8_7_,
milestonet8_.CadCanStart_Realised as CadCanS25_8_7_,
milestonet8_.PrelCAD_Realised as PrelCAD26_8_7_,
milestonet8_.FinalCAD_Realised as FinalCAD27_8_7_,
milestonet8_.NPAIssue_Realised as NPAIssue28_8_7_,
milestonet8_.PrelSpec_Realised as PrelSpec29_8_7_,
milestonet8_.MoldOrder_Realised as MoldOrder30_8_7_,
milestonet8_.MoldDelivery_Realised as MoldDel31_8_7_,
milestonet8_.ConceptGoNoGo_Realised as Concept32_8_7_,
milestonet8_.FinalSpec_Realised as FinalSpec33_8_7_,
milestonet8_.CreatedDate as Created34_8_7_, milestonet8_.ModifiedDate
as Modifie35_8_7_, milestonet8_.Planning_ID as Planning36_8_7_,
milestonet8_.CreatedBy as CreatedBy8_7_, milestonet8_.ModifiedBy as
ModifiedBy8_7_, milestonet9_.PlanningTPSPrinting_ID as
Planning1_88_8_, milestonet9_.ApprovalLicensor_Initial as
Approval2_88_8_, milestonet9_.ArtworkApprovalMarkets_Initial as
ArtworkA3_88_8_, milestonet9_.ArtworkDesignAv_Initial as
ArtworkD4_88_8_, milestonet9_.ColorSamplePP_Initial as
ColorSam5_88_8_, milestonet9_.CostDue_Initial as CostDue6_88_8_,
milestonet9_.KickOfMeeting_Initial as KickOfMe7_88_8_,
milestonet9_.OrderLabels_Initial as OrderLab8_88_8_,
milestonet9_.PhotographySample_Initial as Photogra9_88_8_,
milestonet9_.PRBrief_Initial as PRBrief10_88_8_,
milestonet9_.PRSReqForecastDue_Initial as PRSReqF11_88_8_,
milestonet9_.SampleAppLicensor_Initial as SampleA12_88_8_,
milestonet9_.MAD_Initial as MAD13_88_8_, milestonet9_.TAD_Initial as
TAD14_88_8_, milestonet9_.ApprovalLicensor_Realised as
Approva15_88_8_, milestonet9_.ArtworkApprovalMarkets_Realised as
Artwork16_88_8_, milestonet9_.ArtworkDesignAv_Realised as
Artwork17_88_8_, milestonet9_.ColorSamplePP_Realised as
ColorSa18_88_8_, milestonet9_.CostDue_Realised as CostDue19_88_8_,
milestonet9_.KickOfMeeting_Realised as KickOfM20_88_8_,
milestonet9_.OrderLabels_Realised as OrderLa21_88_8_,
milestonet9_.PhotographySample_Realised as Photogr22_88_8_,
milestonet9_.PRBrief_Realised as PRBrief23_88_8_,
milestonet9_.PRSReqForecastDue_Realised as PRSReqF24_88_8_,
milestonet9_.SampleAppLicensor_Realised as SampleA25_88_8_,
milestonet9_.MAD_Realised as MAD26_88_8_, milestonet9_.TAD_Realised as
TAD27_88_8_, milestonet9_.CostBasedOnQuantity_USD as CostBas28_88_8_,
milestonet9_.CostBasedOnQuantity_EUR as CostBas29_88_8_,
milestonet9_.NrOfColors as NrOfColors88_8_,
milestonet9_.PrintingCompanyName as Printin31_88_8_,
milestonet9_.PrintingTechnique as Printin32_88_8_,
milestonet9_.CreatedDate as Created33_88_8_, milestonet9_.ModifiedDate
as Modifie34_88_8_, milestonet9_.Planning_ID as Planning35_88_8_,
milestonet9_.CreatedBy as CreatedBy88_8_, milestonet9_.ModifiedBy as
ModifiedBy88_8_, milestonet10_.PlanningTTrends_ID as Planning1_2_9_,
milestonet10_.MAD_Initial as MAD2_2_9_, milestonet10_.TAD_Initial as
TAD3_2_9_, milestonet10_.AreaQATesting_Initial as AreaQATe4_2_9_,
milestonet10_.FactoryAudit_Initial as FactoryA5_2_9_,
milestonet10_.FeasibilityApproval_Initial as Feasibil6_2_9_,
milestonet10_.FeedbackSupplier_Initial as Feedback7_2_9_,
milestonet10_.FinalDesign_Initial as FinalDes8_2_9_,
milestonet10_.KickOfMeeting_Initial as KickOfMe9_2_9_,
milestonet10_.PBapproval_Initial as PBapproval10_2_9_,
milestonet10_.PBissue_Initial as PBissue11_2_9_,
milestonet10_.ReceiveFinalSamples_Initial as Receive12_2_9_,
milestonet10_.SamplesNeededForTesting_Initial as Samples13_2_9_,
milestonet10_.MAD_Realised as MAD14_2_9_, milestonet10_.TAD_Realised
as TAD15_2_9_, milestonet10_.AreaQATesting_Realised as AreaQAT16_2_9_,
milestonet10_.FactoryAudit_Realised as Factory17_2_9_,
milestonet10_.FeasibilityApproval_Realised as Feasibi18_2_9_,
milestonet10_.FeedbackSupplier_Realised as Feedbac19_2_9_,
milestonet10_.FinalDesign_Realised as FinalDe20_2_9_,
milestonet10_.KickOfMeeting_Realised as KickOfM21_2_9_,
milestonet10_.PBapproval_Realised as PBapproval22_2_9_,
milestonet10_.PBissue_Realised as PBissue23_2_9_,
milestonet10_.ReceiveFinalSamples_Realised as Receive24_2_9_,
milestonet10_.SamplesNeededForTesting_Realised as Samples25_2_9_,
milestonet10_.CreatedDate as Created26_2_9_,
milestonet10_.ModifiedDate as Modifie27_2_9_,
milestonet10_.Planning_ID as Planning28_2_9_, milestonet10_.CreatedBy
as CreatedBy2_9_, milestonet10_.ModifiedBy as ModifiedBy2_9_,
milestonec11_.PlanningConsumables_ID as Planning1_77_10_,
milestonec11_.MAD_Initial as MAD2_77_10_, milestonec11_.TAD_Initial as
TAD3_77_10_, milestonec11_.KickOfMeeting_Initial as KickOfMe4_77_10_,
milestonec11_.PBapproval_Initial as PBapproval5_77_10_,
milestonec11_.PBissue_Initial as PBissue6_77_10_,
milestonec11_.ArtworkDev_Initial as ArtworkDev7_77_10_,
milestonec11_.FinalPackaging_Initial as FinalPac8_77_10_,
milestonec11_.POPlaced_Initial as POPlaced9_77_10_,
milestonec11_.ProofsApproved_Initial as ProofsA10_77_10_,
milestonec11_.RegulatoryApproval_Initial as Regulat11_77_10_,
milestonec11_.Sampling_Initial as Sampling12_77_10_,
milestonec11_.ArtworkApproval_Initial as Artwork13_77_10_,
milestonec11_.MAD_Realised as MAD14_77_10_, milestonec11_.TAD_Realised
as TAD15_77_10_, milestonec11_.KickOfMeeting_Realised as
KickOfM16_77_10_, milestonec11_.PBapproval_Realised as
PBapproval17_77_10_, milestonec11_.PBissue_Realised as
PBissue18_77_10_, milestonec11_.ArtworkDev_Realised as
ArtworkDev19_77_10_, milestonec11_.FinalPackaging_Realised as
FinalPa20_77_10_, milestonec11_.POPlaced_Realised as
POPlaced21_77_10_, milestonec11_.ProofsApproved_Realised as
ProofsA22_77_10_, milestonec11_.RegulatoryApproval_Realised as
Regulat23_77_10_, milestonec11_.Sampling_Realised as
Sampling24_77_10_, milestonec11_.ArtworkApproval_Realised as
Artwork25_77_10_, milestonec11_.CreatedDate as Created26_77_10_,
milestonec11_.ModifiedDate as Modifie27_77_10_,
milestonec11_.Planning_ID as Planning28_77_10_,
milestonec11_.CreatedBy as CreatedBy77_10_, milestonec11_.ModifiedBy
as ModifiedBy77_10_ FROM Planning projectpla0_ left outer join
PlanningMarketingMilestone marketingm1_ on
projectpla0_.Planning_ID=marketingm1_.Planning_ID left outer join
PlanningGeneral milestonei2_ on
projectpla0_.Planning_ID=milestonei2_.Planning_ID left outer join
PlanningHybrid milestoneh3_ on
projectpla0_.Planning_ID=milestoneh3_.Planning_ID left outer join
PlanningInHouseTestMoldIncluded milestonei4_ on
projectpla0_.Planning_ID=milestonei4_.Planning_ID left outer join
PlanningLicensingPrinting milestonel5_ on
projectpla0_.Planning_ID=milestonel5_.Planning_ID left outer join
PlanningPickUp milestonep6_ on
projectpla0_.Planning_ID=milestonep6_.Planning_ID left outer join
PlanningPrinting milestonep7_ on
projectpla0_.Planning_ID=milestonep7_.Planning_ID left outer join
PlanningTPS milestonet8_ on
projectpla0_.Planning_ID=milestonet8_.Planning_ID left outer join
PlanningTPSPrinting milestonet9_ on
projectpla0_.Planning_ID=milestonet9_.Planning_ID left outer join
PlanningTTrends milestonet10_ on
projectpla0_.Planning_ID=milestonet10_.Planning_ID left outer join
PlanningConsumables milestonec11_ on
projectpla0_.Planning_ID=milestonec11_.Planning_ID WHERE
projectpla0_.rx_...@p0',N'@p0 int',@p0=3022
Can you imagine having 1000 plannings, so 1000 times this query? That
is the problem now...
Please help me or forward this to somebody else who can help me.
Kind regards,
Arne
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
