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 google-appeng...@googlegroups.com.
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
