Identity style generators nullify batcher.But you're using Guid, you're safe.
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, Aug 21, 2009 at 12:48 AM, srf <[email protected]> wrote: > > 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 -~----------~----~----~----~------~----~------~--~---
