It's not a secret. This behavior is clearly documented, and _every_ time offsets come up in discussion Google says "don't use offsets, use cursors" - because that's what you should do.
Yes, offset is expensive and rarely useful. Like the docs say, don't use it unless you really know what you are doing. You shouldn't be pissed at anyone but yourself for not paying attention. The datastore is not an RDBMS. Jeff On Mon, Oct 8, 2012 at 11:07 AM, James Gilliam <[email protected]> wrote: > I discovered that GAE charges you for skipping entities in Datastore with > OFFSET. So, if you want to retrieve 1 record at offset 10, you pay for > reading 11. > > This makes OFFSET expensive and WORTHLESS ... > > Offset should never be mentioned in the documentation without a footnote > that says you can't afford to use it. > > Kinda pissed about this. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-appengine/-/JJAn3Ju-rD4J. > 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. -- 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.
