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 -~----------~----~----~----~------~----~------~--~---
