If the batch size does no work for you perhaps is because this: http://fabiomaulo.blogspot.com/2009/02/nh210-generators-behavior-explained.html
<http://fabiomaulo.blogspot.com/2009/02/nh210-generators-behavior-explained.html>Have a look what happen using identity. 2009/8/20 srf <[email protected]> > > I was tying out the nhProf and it was saying one optimization it was > mentioning was to use batching. For example , in one session I was > inserting 2000 records into the audit_log table and I was doing 2000 > seperate insert statements and it mentioned to us the setBatchSize > command so I used that then I got a message that I needed to set the > ado.Batch_size too so I did that and all was well but I didnt notice > any performance diference so I re ran the nhprof again. It again said > to set the batch size since it was still generating 2000 insert > statements so setting the batch size didnt seem to do anything. I did > some searches and found other people who set the batch size without it > having any effect. Could it be something with the sqlserver driver? Im > using the sql server 2005 dialect and im hitting sql server 2008 . > Also Im running 64bit if that matters. > > Is there anyone else that had this problem as was able to solve this? > > thanks > > scott > > > -- 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 -~----------~----~----~----~------~----~------~--~---
