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?
Slow performance
-
commodoreKid
- Posts: 3
- Joined: Tue 23 Dec 2008 20:40
Slow performance
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?
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?
I've made some tests and here are the results:
- inserting 100,000 rows into a table using SQLiteCommand with parameters - 4:48
- inserting 100,000 rows into a table using LINQ to SQLite - 5:08 (about 7% slower)
- inserting 100,000 rows into the table using a script and sqlite.exe - 4:58.
So, the problem is rather inside the SQLite library.
- inserting 100,000 rows into a table using SQLiteCommand with parameters - 4:48
- inserting 100,000 rows into a table using LINQ to SQLite - 5:08 (about 7% slower)
- inserting 100,000 rows into the table using a script and sqlite.exe - 4:58.
So, the problem is rather inside the SQLite library.