title: PHP Fastest Pagination
body: <p>I have a MYSQL query that returns around 10,000 rows which is used mainly for reporting. </p>
  
  <p>My current pagination code loads all the rows and then cuts them down to whatever the limit per page is which takes ages to load.</p>
  
  <p>I am also using jquery tablesorter to help users sort the results.</p>
  
  <p>Is there a way not to load all rows and make the page load time quicker?</p>