Simon Mourier's Blog - C# Optimisation: Inserting 200 million rows into database

C# Optimisation: Inserting 200 million rows into database

Feb 1, 2011 See the question and my original answer on StackOverflow

For such a big table, you should instead use the

public void WriteToServer(IDataReader reader)

method.

It may mean you'll have to implement yourself a "fake" IDataReader interface with your code (if you' don't get the data from an existing IDataReader), but this way, you'll get "streaming" from end to end, and will avoid a 200 million loop.