It's little off topic, but a good thing to know is that the db.ReferanceProperty doesn't behave like in same fashion one migth think (at least I didn't). Accessing the ReferanceProperty will make a new call against the datastore.
A good you can do if you want look in to what's eating the CPU quota is to use appstats. http://googleappengine.blogspot.com/2010/03/easy-performance-profiling-with.html ..fredrik Sent from my iPad On 8 sep 2010, at 19.46, Eli Jones <[email protected]> wrote: > One way to find out would be to just do a test.. create a model called > PotMemberDeux and make pot = db.StringProperty() in that one.. then test how > long those puts take by assigning pot="p" and use the same put code. > > I'd guess that both of the puts referencing the same pot=p could be what is > slowing it down.. granted, I don't use ReferenceProperty at all... so, what > do I know.. > > On Wed, Sep 8, 2010 at 9:24 AM, Christopher Staite > <[email protected]> wrote: > Hi guys, > > I've been trying write my first real application for the app engine. > After multiple re-writes I've finally got the hang of things. I think > that I've got something efficient and correct. However, it's still > not performing particularly quickly and I'd like to speed it up a > little more. > > The main issue is that most calls have to place two entries into the > datastore: > > class PotMember(db.Model): > pot = db.ReferenceProperty(Pot) > member_id = db.IntegerProperty() > count = db.IntegerProperty() > second_pot = db.BooleanProperty() > purchase_time = db.DateTimeProperty(auto_now_add=True) > process_time = db.DateTimeProperty(auto_now=True) > > newMembers = [] > newMembers.append(PotMember(pot=p, member_id=member_id, count=count, > second_pot=False)) > newMembers.append(PotMember(pot=p, member_id=member_id, > count=second_count, second_pot=True)) > db.put(newMembers) > > This operation takes ~300-400ms, which is enough for App Engine to > complain that my application is executing too slowly and needs to be > "optimised". What exactly is taking so long to place these entries? > Most other put() operations take ~10ms to complete. Is it the use of > the DateTimeProperty or the use of the ReferenceProperty that is > slowing this call down? > > Any help would be appreciated. > > Many Thanks, Chris. > > -- > 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. -- 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.
