C# System.Data.SQLite Designer Code
Posted
by Nathan
on Stack Overflow
See other posts from Stack Overflow
or by Nathan
Published on 2010-01-07T04:35:43Z
Indexed on
2010/04/04
0:03 UTC
Read the original article
Hit count: 741
I've been messing around with the SQLite Designer in Visual Studio 2008 and I have noticed that when I use the generated Insert/Update statements they run extremely slow.
Example: I have a data table with four columns and 5700 rows it took ~5 mins to insert the data into the database table
However, I wrote my own database connection and insert methods using parameters and a single transaction and the same 5700 rows were inserted in under 1 second.
Why is the generated code so slow and what is benefit to even using it?
Thanks.
Nathan
© Stack Overflow or respective owner