nhibernate - 'Bulk insert' for cascaded list -
i have object cascaded list mapped in following way:
hasmany(x => x.products).cascade.alldeleteorphan(); //.batchsize(10000);
after adding 20000 products list, commit takes more 30 seconds (while should max 3 seconds).
what need kind of bulk insert. follow approach: speed bulk insert operations nhibernate. know solution uses statelesssession
anyway, hope configure these things in mapping, adding objects directly list in entity
, nhibernate
takes care of remaining stuff. setting batchsize
on mapping of list seems has no effect.
is there way accomplish task in acceptable time?
i think batch size in mapping related fetching. can try using configuration in nhibernate config:
<property name="adonet.batch_size">250</property>
Comments
Post a Comment