title: Insert takes too long, code optimization needed
body: <p>I've some code I use to transfer a <code>table1</code> values to another <code>table2</code>, they are sitting in different database.  </p>
  
  <p>It's slow when I have 100.000 records. It takes forever to finish, 10+ minutes.</p>
  
  <p><strong>(Windows Mobile smartphone)</strong></p>
  
  <p>What can I do?</p>
  
  <pre><code>cmd.CommandText = "insert into " + TableName + " select * from sync2." + TableName+"";  
  cmd.ExecuteNonQuery();
  </code></pre>
  
  <p><strong>EDIT</strong> </p>
  
  <p><strong>The problem is not resolved. I'm still after answers.</strong></p>