850 records in 15 seconds is still really, really slow :)
Are your inserts complicated so that you need a stored procedure?
With a proper bulk insert you could do all of that in less than a second.
Yes, I checked your suggestion with the proper SQL bulk insert. It now works, indeed around 1 second. I needed to convert the List to Datatable using the suggested method. Thank you! :)
There you go, way better than initial way you had it. Also tons of times faster.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
850 records in 15 seconds is still really, really slow :)
Are your inserts complicated so that you need a stored procedure?
With a proper bulk insert you could do all of that in less than a second.
Yes, I checked your suggestion with the proper SQL bulk insert. It now works, indeed around 1 second. I needed to convert the List to Datatable using the suggested method. Thank you! :)
There you go, way better than initial way you had it. Also tons of times faster.