It was clear that if I can have a criteria that would return a result
set starting with the 1001 row than the problem would be solved. But,
if you read my question you'll notice that I was clearly referring to
result sets that have more than 1000 results. Anyways, I do believe
that my understanding of this 'limitation' is correct and this means
that while designing your model you'll have to always prepare it for
this case (not to forget the way you are writing the queries).
./alex
On Oct 27, 1:58 am, djidjadji <[EMAIL PROTECTED]> wrote:
> You can but you must use a field of the object that you can sort on.
> Then you can use a filter() on the query to get the objects beyond the
> first 1000.
> If you fetch 1000 records, process 999, and use the sort field value
> of record 1000
> as a starting value for your next query.filter('field >= :1',
> record[999].field) statement
>
> 2008/10/27 Alex Popescu <[EMAIL PROTECTED]>:
>
>
>
> > I am reading on the chapter "Executing the Query and Accessing
> > Results" [1]:
>
> > [quote]
> > The datastore returns a maximum of 1000 results in response to a
> > query, regardless of the limit and offset used to fetch the results.
> > The 1000 results includes any that are skipped using an offset, so a
> > query with more than 1000 results using an offset of 100 will return
> > 900 results.
> > [/quote]
>
> > So, if the result set matching the given criteria has more than 1000
> > results, you'll never be able to access anything over the 1000th row
> > (even if you are specifying a 1000 offset).
>
> > [1]http://code.google.com/appengine/docs/datastore/creatinggettinganddel...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
