I was a little confused, does the identity column type effect batched inserts and it will only work unser certain situations? thanks
scott On Aug 20, 9:28 am, Fabio Maulo <[email protected]> wrote: > If the batch size does no work for you perhaps is because > this:http://fabiomaulo.blogspot.com/2009/02/nh210-generators-behavior-expl... > > <http://fabiomaulo.blogspot.com/2009/02/nh210-generators-behavior-expl...>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- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
