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 <lenny...@gmail.com> 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 google-appeng...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-appengine+unsubscr...@googlegroups.com.
> 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 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.
