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

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -