title: Fill() Method becomes slow in .net (ADO)
body: <p>In my .net application am facing a <code>performance problem</code>. One of my Stored procedure dealing with more than <code>two tables having 30,000 records</code>. But the <code>SP itself returns fastly</code>. but in my <code>DataAccesss</code> it will take more time for fill that into <code>DataTable</code></p>
  
  <p>My datataccess is</p>
  
  <pre><code>cmd.CommandType = CommandType.StoredProcedure;//cmd-sqlcommand object
  conn.Open();//conn-sqlconnection object
  adpt = new SqlDataAdapter(cmd);
  DataTable dt = new DataTable();
  adpt.Fill(dt);
  conn.Close();
  
  return dt;
  </code></pre>
  
  <p>If any body know the solution for better performance please share.</p>