Your original assumption is correct. fetch() first gets the objects
and then applies the offset.
Maybe they have set this limit, because retrieving and processing 1000
objects will trigger some sort of quota, time or CPU.
2008/10/28 Alex Popescu <[EMAIL PROTECTED]>:
>
> 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 [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
-~----------~----~----~----~------~----~------~--~---
