How to Insert 1 million items of data in database in more efficient way?

Question

Main()
{
     WinOpTableAdapters.attendanceTableAdapter tx;
     tx = new WinOpTableAdapters.attendanceTableAdapter();

     Thread th = new Thread(new ThreadStart(Insrt));  //thread
     th.Start();
}

void Insrt()
{
    WinOpTableAdapters.attendanceTableAdapter tx;
    tx = new WinOpTableAdapters.attendanceTableAdapter();

    for (int j = 0; j <= 100000; j++)
    {
        tx.InsertQueryAttend("Admin" + j);
    }
}

I want to insert 1 million items of data into a database in more efficient way, the code shown takes 5 mins to insert 5000 rows into database

are you using Entity framework ? – Frebin Francis Mar 06 '15 at 05:32 — Frebin Francis, Mar 06 '15 at 05:32

score 0 · Answer 1 · edited May 23 '17 at 11:43

0

SqlBulkCopy is the best method to copy large amounts of data into a database. Some examples for SqlBulkCopy

If you are using Entity Framework, https://stackoverflow.com/a/9162325/311255

edited May 23 '17 at 11:43

Community

1
1

answered Mar 06 '15 at 05:41

SelvaS

1,771
1
22
28

How to Insert 1 million items of data in database in more efficient way?

1 Answers1