title: what is the technique to process 1 million records from a database
body: <p>This is more or less a design question. we have to process like a 1 million rows and send an xml to a third party. Initially we have to send like 1 million records, later we will send the deltas only.</p>
  
  <p>Right now the stored procedure is taking approchimately around 15 to 20 min to return the  data. Its a consoleapp right. I know its not a good way to get 1 million records at time.</p>
  
  <p>I want to know the following things
  1) Is console app in c# which connects to database is right approach or not
  2) Are there any other ways of doing this?</p>
  
  <p>Appreciate your guidence on this , there is no need for any coding or so , We need some some advice on how to proceed.
  Thanks in advance.</p>