title: Sql Connection open slow down or make application performance better
body: <p>I am querying  to a table  for specific records having 5,00,000  records in application.
  When ever i query </p>
  
  <p>eg:</p>
  
  <pre><code>...........  Some Code
  
  for i = 0 ;  i &lt; 60,000
  
  .............  Some code
  
  connection.Open();
  
  select * from ERet where [Key] = Variable+i ;
  
  connection.Close();
  --------------some calculation
  
  .............some code
  
  next
  </code></pre>
  
  <p>Should this connection.open/close will affect the application performance?
  Should i need connection to open before the loop and close after loop for the better application performance.</p>