title: Google app engine and paging
body: <p>How would one go about writing a query that selects items 2000-2010 out of a collection of 10000 objects in the data store. </p>
  
  <p>I know that it can be done like this in GQL:</p>
  
  <pre><code>select * from MyObject limit 10 offset 2000
  </code></pre>
  
  <p>According to the <a href="http://code.google.com/appengine/docs/python/datastore/gqlreference.html" rel="noreferrer">documentation</a>, when using an <code>offset</code> the engine will still fetch all the rows, only not return them, thus making the query perform in a way that corresponds linearly with the value of <code>offset</code>.</p>
  
  <p>Is there any better way? Such as using a pseudo <code>ROWNUM</code> column like one could do in other types of data stores.</p>