General good start depends on get or post you always can benchmark( why you need http post
On May 22, 8:53 pm, Lenny Rachitsky <[email protected]> wrote: > I have the following query and associated fetch: > > query = db.GqlQuery("SELECT * FROM VenueHistory WHERE venue_id > = :venue_id ORDER BY time desc", venue_id=str(venue_id)) > results = query.fetch(1000) > > The VenueHistory data model is such: > > class VenueHistory(db.Model): > venue_id = db.StringProperty(required=True) > males = db.IntegerProperty(required=True) > females = db.IntegerProperty(required=True) > time = db.DateTimeProperty(auto_now_add=True) > checkedin_users = db.ListProperty(str) > > In production app stats, the "query.fetch(1000)" request is seeing > performance on average around 20507ms (9179ms api). Often times it > times out. > > Is this expected? Should I expect > 20 second run times from a fetch > of 1000 results? Any advice on getting back this amount of data more > efficiently? > > Thank you in advance, > Lenny > > -- > 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 > athttp://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.
