Fabio, I'll get working on ConfORM and let you know.
The xml snippet is supposed be telling NH that the ID for the primary table is also the key into the Plan object (which is my one-to-one association). On Mar 24, 12:01 am, Fabio Maulo <[email protected]> wrote: > Try to map your domain with ConfORM and let me know if you see > the improvement (unidirectional one-to-one mapping pattern) > > Before do it try to explain me what mean this > <generator class="assigned"> > <param name="property"> > Plan > </param> > </generator> > > Thanks. > > 2010/3/24 jprid64 <[email protected]> > > > > > > > Thanks, Diego. That worked (sort of) for my one-to-many. I set the > > batch size to 20 (knowing I would only get 15 based on the data I'm > > testing with) and it gave me a query for 10 and a query for 5. Still > > an improvement, but I'm a bit puzzled in the discrepancy. I'll play > > around with it a bit more tomorrow. > > > That still leaves the question of how to deal with my one-to-one, as > > I'm not aware of any batching parameters for that type of > > relationship. > > > On Mar 23, 9:43 pm, Diego Mijelshon <[email protected]> wrote: > > > Have you tried with batch-size? > > > It's usually more efective than fetch strategies, because: > > > - It doesn't force loading of not-always-used elements > > > - It doesn't create a bigger, denormalized result set > > > ...And it still turns a select N+1 problem into a "select N/x+1" one > > (which > > > is effectively "select 1+1" if you adjust the batch-size to your page > > size. > > > I do that). This can be more efficient than a single select in many > > cases. > > > > Diego > > > > On Tue, Mar 23, 2010 at 21:45, jprid64 <[email protected]> wrote: > > > > I have two tables that have a 1 to 0,1 relationship. I have the basic > > > > mapping set up (read-only for now) for my ASP.NET MVC app using lazy > > > > loading but NHProf shows that I am making separate SQL queries to the > > > > secondary table for each row returned from the primary table. I've > > > > played with various combinations of lazy, outer-join, and fetch, but > > > > all of them still generate N queries. FWIW, I have a 1 to many in here > > > > as well that exhibits the same behavior. Please note that all data > > > > returned is correct -- I just think it's doing too much work. > > > > > Here are my XML mappings (reverted to basic association): > > > > > Primary table: > > > > <class name="AladdinDb.Models.OrderStatus, AladdinDb" > > > > table="vorder_status"> > > > > <id name="CommitNumber" type="decimal" column="commit_no"> > > > > <generator class="assigned"> > > > > <param name="property"> > > > > Plan > > > > </param> > > > > </generator> > > > > </id> > > > > <property name="MainCommit" column="main_commit" > > > > type="decimal" /> > > > > <property name="InvoiceNumber" column="invoice_no" > > > > type="string" /> > > > > <property name="ShipTo" column="ship_to" type ="string"/> > > > > <property name="CustomerOrderNumber" column="cust_order_no" > > > > type="string" /> > > > > <property name="Station" column="station" type="string" /> > > > > <property name="RequestedShipDate" column="req_ship_date" > > > > type="DateTime" /> > > > > <property name="EstimatedValue" column="estimated_value" > > > > type="decimal"/> > > > > <property name="EstimatedWeight" column="estimated_weight" > > > > type="decimal" /> > > > > <property name="Customer" column="customer" type="string" /> > > > > <property name="InvoiceDate" column="invoice_date" /> > > > > <one-to-one name="Plan" class="AladdinDb.Models.PlanCommit, > > > > AladdinDb" /> > > > > <set name="Promises" > > > > > <key column="commit_no"></key> > > > > <one-to-many class="AladdinDb.Models.Promise, AladdinDb" / > > > > > </set> > > > > </class> > > > > > One-to-zero/one table: > > > > <class name="AladdinDb.Models.PlanCommit, AladdinDb" > > > > table="plan_commit"> > > > > <id name="CommitNumber" type="decimal" column="commit_no"> > > > > <generator class="assigned" /> > > > > </id> > > > > <property name="Priority" column="priority" /> > > > > <property name="Done" column="done" /> > > > > <property name="CStatus" column="c_status" /> > > > > <property name="Hauler" column="hauler" /> > > > > <property name="WarehouseRandomWeight" column="whar_rand" /> > > > > <property name="WarehouseCutsWeight" column="whar_cuts" /> > > > > <property name="YardRandomWeight" column="yard_rand" /> > > > > <property name="YardCutsWeight" column="yard_cuts" /> > > > > <property name="ShipDate" column="ship_date" /> > > > > </class> > > > > > One-to-many table: > > > > <class name="AladdinDb.Models.Promise, AladdinDb" table="promise"> > > > > <id name="CommitNumber" type="decimal" column="commit_no"> > > > > <generator class="assigned" /> > > > > </id> > > > > <property name="PromiseDate" column="promise_date" /> > > > > <property name="WhoAsked" column="who_asked" /> > > > > <property name="WhoGave" column="who_gave" /> > > > > <property name="Iffy" column="iffy" /> > > > > </class> > > > > > -- > > > > 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]<nhusers%[email protected] > > > > > > > <nhusers%[email protected]<nhusers%252bunsubscr...@googlegroup > > s.com>> > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/nhusers?hl=en. > > > -- > > 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]<nhusers%[email protected] > > > > > . > > For more options, visit this group at > >http://groups.google.com/group/nhusers?hl=en. > > -- > Fabio Maulo -- 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.
