Google app engine and paging

Posted by klausbyskov on Stack Overflow See other posts from Stack Overflow or by klausbyskov
Published on 2010-04-16T07:34:34Z Indexed on 2010/04/16 13:13 UTC
Read the original article Hit count: 310

Filed under:
|

How would one go about writing a query that selects items 2000-2010 out of a collection of 10000 objects in the data store.

I know that it can be done like this in GQL:

select * from MyObject limit 10 offset 2000

According to the documentation, when using an offset 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 offset.

Is there any better way? Such as using a pseudo ROWNUM column like one could do in other types of data stores.

© Stack Overflow or respective owner

Related posts about google-app-engine

Related posts about gql