I'd say the huge "Note" is pretty blatantly obvious: https://img.skitch.com/20121009-xxm3tru195tjysm1sj913umj1t.jpg
Offset has its uses. But annoying people who don't read documentation, blame other people for their mistakes, and post in all caps can figure it out for themselves. Jeff On Mon, Oct 8, 2012 at 12:25 PM, James Gilliam <[email protected]> wrote: > 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]> 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.
