title: Why is this sphinx query so slow? ORDER BY id DESC
body: <pre><code>SELECT id FROM postalcodes ORDER BY id DESC LIMIT $x, 1
  </code></pre>
  
  <p>$x is a number &lt; 1000 (due to max_matches) and postalcodes index contains ~1,1 million rows.</p>
  
  <p>Query time: 0,17 seconds</p>
  
  <p>Why does it take so long time? Is there a better way to query in the end of the index?</p>