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) - 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.
