title: C# System.Data.SQLite Designer Code
body: <p>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.</p>
  
  <p>Example: I have a data table with four columns and 5700 rows it took ~5 mins to insert the data into the database table</p>
  
  <p>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.</p>
  
  <p>Why is the generated code so slow  and what is benefit to even using it?</p>
  
  <p>Thanks.</p>
  
  <p>Nathan </p>