title: Asp.NET MVC How to quickly display large amount of data in datatables
body: <h2>Background</h2>
  
  <p>I have an ASP.net MVC 4 web application written in VB and Razor, and using MySQL as its data source.</p>
  
  <p>I need a view to display a table containing an ever expanding amount of data. (Potentially up to 10's of thousands of rows and maybe more.)</p>
  
  <p>In order for me to continue further development, I have temporarily implemented a basic data-table where all rows are written to the page and then handled by the data-table thereafter. This works fine with up to a few hundred rows, but the more rows there are, the slower it gets and page loading times plummet!</p>
  
  <h2>Question</h2>
  
  <p>How do I implement the data table in such a way that data is retrieved and displayed only when needed so as to keep consistent page loading times, but also keep the searching and sorting functionality?</p>
  
  <h2>Additional notes</h2>
  
  <p>My guess is that the data-table must call something server side to pass only the required data, but I have no idea where to begin with this.</p>