title: MySQL large table performance issues when paging with PHP
body: <p>Have a huge mysql table with like 300,000 records and wanted to page the records in PHP (not the point here though) with a query in this manner:</p>
  
  <pre><code>SELECT * FROM `table` LIMIT 250000, 100 
  </code></pre>
  
  <p>It could be majorly slow in the latter part of the records, especially when near the end of the table (LIMIT start very large). My guess is MySQL has to count all the way down to exactly 250000 before scooping the results to me?</p>
  
  <p>So how to work around this or any other approach for paging that could be much faster? Thanks!</p>