Performance Impact: the Most Optimal Insert Script can’t Beat BulkCopy

(Linchi Shea) With the insert script and the test configurations in my previous posts, the best data load throughput was 24GB in ~7 minutes when the checkpoint (and/or transaction commit) batch size was set to 100,000 ~ 1,000,000. That was the best result when I was trying to get the most out of the

Read More - Register for Free Membership