BTW, I really like the blog post Emlyn. On Sun, Sep 4, 2011 at 11:54 PM, Alfred Fuller < [email protected]> wrote:
> > > On Sat, Sep 3, 2011 at 8:23 AM, johnP <[email protected]> wrote: > >> >> Which leads to a potential constructive suggestion. Maybe Goog can >> post a troubleshooting guide that lists different line-items in the >> new-style billing, and potential gotchas? An example in your blog is >> that sudden parallelism is costly and that making things serial is a >> good optimization. (Ironically, the opposite of what was being >> promoted earlier - mapreduce). Another factoid is that offset queries >> are costly. Using queries as a generator is costly, and you should >> fetch items at once. >> >> So it can look like this: >> >> Excessive instances cost? Look at these items: >> - sudden parallelism >> - idle instance setting >> - decrease response time >> - other? >> >> Excessive writes: >> - decrease unneeded indexes >> - >> >> Excessive Reads: >> - make sure your fetch() rather than looping through results >> > > If you look or use fetch the cost is the same (though fetch might be faster > as it will pick larger batch sizes) > ...if you *loop or... :-) > > - check offset queries >> > > I am sure this is the culprit in Emlyn's case. Use query cursors ( > http://code.google.com/appengine/docs/python/datastore/queries.html#Query_Cursors) > not offsets! :-) > > - etc... >> >> >> >> >> >> >> >> >> >> On Sep 3, 4:36 am, peterk <[email protected]> wrote: >> > Very good read, thanks for posting. Will definitely be curious to see >> > how your changes improve things or otherwise. >> > >> > On Sep 3, 11:16 am, Emlyn <[email protected]> wrote: >> > >> > >> > >> > >> > >> > >> > >> > > Hi all, >> > >> > > I don't think I've posted here before, but I've been an appengine user >> > > for a while now (closing on 2 years? Is that even possible?). And like >> > > many, I had a rude shock with the new pricing (going from $0.50/day to >> > > $50/day). >> > >> > > However, I dug into what I'm actually being charged for, and I think >> > > it's all actually in my control to sort out, and that in itself is >> > > sort of fascinating. I wrote a long blog post on this, which people >> > > might find interesting. >> > >> > > The Amazing Story Of Appengine And The Two Orders Of Magnitudehttp:// >> point7.wordpress.com/2011/09/03/the-amazing-story-of-appengine... >> > >> > > I'd be really grateful for feedback, especially if I've gotten >> > > anything wildly wrong. I haven't actually made any of the changes that >> > > I've foreshadowed in the post, that's for the next day or two, and >> > > I'll write a followup article on how it goes. >> > >> > > Thanks in advance for having a look! >> > >> > > -- >> > > Emlyn >> > >> > >http://my.syyn.cc-Synchonise Google+, Facebook, WordPress and Google >> > > Buzz posts, >> > > comments and all.http://point7.wordpress.com-My blog >> > > Find me on Facebook and Buzz >> >> -- >> 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. >> >> > -- 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.
