I do use cursors a lot but had no idea that offset is so expensive ... IT IS ONLY MENTIONED ONCE IN THE DOCUMENTATION
My point is WHY HAVE OFFSET AT ALL ? IT IS WORTHLESS JUST AS I SAID IN MY ORIGINAL POST. IF YOU WANT OFFSET, JUST READ ALL THE RECORDS -- COST THE SAME. On Monday, October 8, 2012 11:35:29 AM UTC-7, Jeff Schnitzer wrote: > > 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]<javascript:>> > 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]<javascript:>. > > > To unsubscribe from this group, send email to > > [email protected] <javascript:>. > > 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 view this discussion on the web visit https://groups.google.com/d/msg/google-appengine/-/h3l268aPR3EJ. 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.
