title: Paging with PagedList, is it efficient?
body: <p>I have been trying to implement paging for quite a while now and I found this tutorial for paging with MVC: <a href="http://devproconnections.com/aspnet-mvc/aspnet-mvc-paging-done-perfectly" rel="noreferrer">ASP.NET MVC Paging Done Perfectly</a></p>
  
  <p>Now, in this solution, I query the database for the <strong>entire set of clients</strong> and then I return a paged list of clients instead of a normal list. </p>
  
  <p>I find this disturbing, because I only plan to show 10 or 20 entries per page, and my database will easily have over a million of them. Thus, querying the entire database each time I want to show the <code>Index</code> page seems to be a poor solution at best.</p>
  
  <p>If I am understanding something wrong, please feel free to cut me right now, but for me this solution is anything but perfect.</p>
  
  <p>Have I misunderstood something? Is there a more efficient solution or library out there for pagination with MVC?</p>