title: SQL pagination when ordering by modified date
body: <p>I have a bunch of records that I want to paginate by reverse modified date. From what I can tell, using a simple query pulls the same sub-set of records and then sorts only those by date.</p>
  
  <p>Something like this:</p>
  
  <pre><code>SELECT * FROM items WHERE status='1' ORDER BY modified_date DESC LIMIT start,count
  </code></pre>
  
  <p>Would an index help me? Or am I going to have to figure out some way to code this perhaps adding a column that somehow keeps track of modified_date in reverse order?</p>