there is a very similar question: Performance Inserting and Updating Millions of rows into a tablePerformance Inserting and Updating Millions of rows into a table
This question is also relevant: What is the fastest way to insert large numbers of rows?What is the fastest way to insert large numbers of rows?