title: SQL query Takes Too much Time
body: <p>I am reading a lot of data from 5 files at a time each file has 100,000 records, it takes too much time while inserting it into a table using a SQL query. Is there any way that insertion into the table take's less time?</p>
  
  <p>My SQL query is </p>
  
  <pre><code>comm = new SqlCommand("INSERT INTO try(DistrictName, TownName, FarmerName, Area, VarietyOfCrop) " + 
                        "VALUES(@p1, @p2, @p3, @p4, @p5)", con);
  
  comm.Parameters.AddWithValue("@p1",DataTokenz[0]);
  comm.Parameters.AddWithValue("@p2", DataTokenz[1]);
  comm.Parameters.AddWithValue("@p3", DataTokenz[2]);
  comm.Parameters.AddWithValue("@p4", DataTokenz[3]);
  comm.Parameters.AddWithValue("@p5", DataTokenz[4]);
  </code></pre>