title: How do I process large amount of data in asp.net
body: <p>I have a web project in asp.net/C#/Mysql where the data can be up to some 30,000 rows of data to process.
  Its a reporting tool, and I have to show statistics like counts and sum at several levels.</p>
  
  <p>I want to know which would be the better way to go around this.</p>
  
  <p>I can filter my data to limited columns though which I can query.</p>
  
  <ol>
  <li><p>Now, Is is a good way to get the data (all rows) to my application <strong>on load</strong> and whenever user queries I can filter that data and do my <strong>calculations in the code</strong> and show my statistics.</p></li>
  <li><p>or I can have a <strong>stored procedure</strong> do all my calculations and every time user queries I can call the stored procedure and get my statistics.</p></li>
  </ol>
  
  <p>Thanks</p>