Hello everyone,

Im facing very irritating problem. I use LINQ to get data from sql server then I do sth with it create new objects and I want to insert thos newly created objects into database.

There is over 130 000 000 records that I have to proceed. In first iteration I take 10000 records and process them and In result I have new sth like 7000 new records that I need to insert to different table.

Processing this records takse sth like 0,03 s. And there is the problem. Inserting this data using DataContext.SubmitChanges takes over 12 s.

Using SqlBulkCopy doesnt help while it takes ~17 s to to the same.

If I'm lucky It would take 39 h to proceed all 130 000 000 records and insert output to table in database.

Is there aby other way I can make performance better ?

Thanks for help