Are you using auto-incremental ids? ----- Original Message ----- From: "srf" <[email protected]> To: "nhusers" <[email protected]> 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 > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
