I tried the tests from two locations now. Same results on the poor
performance. I profiled the app. but found nothing obvious.
Is there a way to download all the profile data?
Some of my requests are now taking 11000ms. However, the same request
a second time might take only 400ms. I'm at a loss. I'm only
fetching 25 from the first page.
action_gql = Action.gql("WHERE project = :1 and state = :2 and
archived = :3 and milestone = :4 ORDER BY state DESC, due ASC,
priority DESC, summary ASC", project_key, 0, False, db.Key(milestone))
This is an example query. Possibly the ORDER BY?
Barry
P.S. Sorry if this is a double post, my session seemed to have
expired right after I hit send, so I don't know if the original made
it.
On Sep 3, 12:12 am, "Brandon N. Wirtz" <[email protected]> wrote:
> http://speed-test.appspot.com/
>
> If you want to rule out your network connection this is a good way to do
> that... Even if it won't test super fast connections with perfect accuracy,
> your connection should always score about the same. I have found that I get
> some drastically different results on my home 20 meg Comcast connection at
> different times of the day compared to testing from my colo's rack, where as
> Speak easy always tests the same (I suspect that Comcast has figured out
> that giving priority to speed tests is good for blaming other people for
> their problems...
>
> -Brandon Wirtz
>
> -----Original Message-----
> From: [email protected]
>
> [mailto:[email protected]] On Behalf Of Sylvain
> Sent: Thursday, September 03, 2009 12:03 AM
> To: Google App Engine
> Subject: [google-appengine] Re: Performance of site seems much slower after
> maintenance.
>
> For my part, all seem faster...
>
> On Sep 3, 4:01 am, bvelasquez <[email protected]> wrote:
> > Hello,
>
> > My application (ID: jacob-6) seems to be performing worse after the
> > maintenance of yesterday. I have not made any significant changes
> > that would affect performance to this degree, but I definitely see a
> > change since yesterday. Requests are taking much longer and is
> > unpredictable. For example, look at the following two requests. Both
> > for the exact same information, doing the exact same processing. The
> > times are very close since I ran the request manually. The first took
> > much longer to process.
>
> > 09-02 06:56PM 13.604 /project/topactions/
> > agdqYWNvYi02cg4LEgdQcm9qZWN0GOoHDA?
> > milestone_id=agdqYWNvYi02chALEglNaWxlc3RvbmUY4zYM 200 329ms 385cpu_ms
> > 151api_cpu_ms
>
> > 09-02 06:55PM 51.014 /project/topactions/
> > agdqYWNvYi02cg4LEgdQcm9qZWN0GOoHDA?
> > milestone_id=agdqYWNvYi02chALEglNaWxlc3RvbmUY4zYM 200 1508ms
> > 1240cpu_ms 151api_cpu_ms
>
> > This behavior is happening across all my requests.
>
> > I'll try it from a different network connection when I go home
> > tonight. Maybe this has something to do with it.
>
> > Any ideas? My app went from pretty snappy to pretty slow overnight.
>
> > Barry
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
