News for hackers. Stuff that matters.
Re:SQL Notebook by voltagex_ on Tuesday May 09, 2017 @11:28PM (#14305719)
I've never been able to match bcp's speed when importing large amounts of data, though.
Re:SQL Notebook by Pxtl on Tuesday May 09, 2017 @11:48PM (#14305792)
I've never had an import job where run time was a key concern... but the old ADO.Net Bulk Insert thingy has always been good enough when Entity Framework was too slow (which, for inserts, it generally is).
Re:SQL Notebook by flukus on Wednesday May 10, 2017 @01:18AM (#14306071)
How large a job are you talking? Did you use a transaction? A transaction + being in a nearby location has been good enough for every import I've done (millions of rows).