How to insert around 2.5 million records from table value parameter as quickly as possiblem

Oct 28, 2011 at 8:25 AM

hi All,

I am using table value parameter to inserting records into database.I am sending at maximum of 20,000 records chunks

Is there possibility i can increase the chunks or insert the data faster?

Oct 29, 2011 at 6:33 AM

I don't think you will know without doing some measurements of the different approaches.  SqlBulkCopy is quite fast for bulk inserts so you may also want to investigate that.  

This MSDN article indicates that for a remote client process performing more than 1000 direct insert a bulk operation will be better than table valued parameters.

Randy Levy
Enterprise Library support engineer