Hi, The same is not true of filter(). Filter will start at the first value larger than x, and should be used if you want to paginate your records.
Brett Slatkin's IO talk covers scalable pagination recipes, and I suggest checking it out: http://sites.google.com/site/io/building-scalable-web-applications-with-google-app-engine -Marzia On Mon, Oct 13, 2008 at 6:24 AM, David Wilson (entertainment cloud) < [EMAIL PROTECTED]> wrote: > > ok, i wanted to be sure about this, as pulling all the records and > just returning one would have been a performance disaster for my app. > > my question was raised because i was a little surprised to read that > offset queries still pull all the 'upto' offset out of the store. > > does the same apply to Thing.all().filter('value >' x).get() ? > > and thus is it possible to page without pulling all the previous pages > data from the store each time? > > > > On Oct 13, 1:01 pm, Sylvain <[EMAIL PROTECTED]> wrote: > > Only '1' > > > > http://code.google.com/appengine/docs/datastore/queryclass.html#Query... > > > > On 13 oct, 13:41, "David Wilson (entertainment cloud)" > > > > <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > class Thing(db.Model): > > > > > value = db.IntegerProperty(required=True) > > > > > datastore has 10 Things with value 1..10 > > > > > Question: > > > > > How many records does the query Thing.all().order('-value').get() pull > > > from the datastore? > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en -~----------~----~----~----~------~----~------~--~---
