I would be sure of what you are using.Please send here (using copy&paste) the NH configuration and the id-mapping of each entity involved in what you are testing.
2009/8/20 srf <scott.fl...@cmgl.ca> > > no, Im using Guids as the Id, should that effect trying to do batched > inserts? > > thanks > > scott > > On Aug 20, 11:03 am, "Cesar Sanz" <the.email.tr...@gmail.com> wrote: > > Are you using auto-incremental ids? > > > > > > > > ----- Original Message ----- > > From: "srf" <scott.fl...@cmgl.ca> > > To: "nhusers" <nhusers@googlegroups.com> > > Sent: Thursday, August 20, 2009 7:55 AM > > Subject: [nhusers] batch_size > > > > > 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- Hide quoted text - > > > > - Show quoted text - > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---