title: SQLite Insert very slow?
body: <p>I recently read about SQLite and thought I would give it a try. When I insert one record it performs okay. But when I insert one hundred it takes five seconds, and as the record count increases so does the time. What could be wrong? I am using the SQLite Wrapper <code>(system.data.SQlite)</code>:</p>
  
  <pre><code>dbcon = new SQLiteConnection(connectionString);
  dbcon.Open();
  
  //---INSIDE LOOP
  
   SQLiteCommand sqlComm = new SQLiteCommand(sqlQuery, dbcon);
  
   nRowUpdatedCount = sqlComm.ExecuteNonQuery(); 
  
  //---END LOOP
  
  dbcon.close();
  </code></pre>