Slow performance
Posted: Wed 31 Dec 2008 20:05
I am trying to add 10,000 records to a database and it is taking about 5 minutes. I doing it through a DataContext object like this:
Deleting records is taking just as long too.
I will eventually need to be able to add and delete 100,000's of rows quickly. Is there some way that I can make things faster?
Code: Select all
dataContext.MainTable.InsertAllOnSubmit(recordObjects);
I will eventually need to be able to add and delete 100,000's of rows quickly. Is there some way that I can make things faster?