title: Speed up insert mdb
body: <p>Is there a way to speed up inserts to a mdb?</p>
  
  <pre><code> using (StreamReader sr = new StreamReader(_localDir + "\\" + _filename))
    while ((line = sr.ReadLine()) != null)
  {
     //sanitize the data
  }
  </code></pre>
  
  <p>This takes about 20sec for ~2mil records from a csv
  but when I add in the mdb insert I can barely get 10,000 records in 10min, so you can see it'll take forever</p>
  
  <pre><code> using (StreamReader sr = new StreamReader(_localDir + "\\" + _filename))
   while ((line = sr.ReadLine()) != null)
  {
  //sanitize the data
  using (OleDbConnection con = new OleDbConnection(_conStr))
   using (OleDbCommand cmd = new OleDbCommand())
   cmd.Parameters.AddWithValue...//I have 22 params
  cmd.ExecuteNonQuery();
  
  }
  </code></pre>
  
  <p>Is there a better way? Connection pooling? threading?
  Here is my constr Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mypath;Jet OLEDB:Engine 
  Type=5"</p>
  
  <p>Regards</p>
  
  <p>_Eric</p>