Today, we had a very interesting service request that our customer requested to improve the process for inserting 10 millions of rows.
In this type of situation, we need to think about the the time spent in networking roundtrips.
In order to explain this I developed three different Powershell Scripts that you could find out in this GitHub repository
In all the tests done, InsertBulk was the process that much faster inserted the data.
Enjoy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.