hi NIcholas, its the same request that is taking different time to complete the task, in my case two users are accessing same row at the same time and the row it self has a size of 100KB ,its a turn based game, so first turn it works perfectly , second turn you will get this delay of at least 3 to 4 minutes,every turn is an updation to the same row, is it because of the size of the row, i run the same application on compute engine keeping my db within compute engine everything works as expected.
On Thursday, July 28, 2016 at 2:23:50 AM UTC+5:30, Nicholas (Google Cloud Support) wrote: > > It's somewhat difficult to tell from your description what the cause of > the slowness might be. Just to clarify, in Stackdriver Traces, the latency > for a given request appears to be the time taken from when the client > request is received and when the server response is sent. Is this in fact > the latency you are seeing below 1.5 seconds? Are these the same requests > that take longer than 3 or 4 minutes? Is this slowness specific to a given > URL handler or are all handlers slow? Could you elaborate on what this > slow handler is doing in a linear way like so? > > - Receive request > - Authenticate user > - Parse user input > - Connect to Cloud SQL instance > - Insert new row > - Disconnect from Cloud SQL instance > - Send response to user > > A description of tasks performed by a given handler can be very helpful in > identifying bottlenecks. > > On Wednesday, July 27, 2016 at 4:39:29 AM UTC-4, ANOOP M.S wrote: >> >> >> 0down votefavorite >> <http://stackoverflow.com/questions/38607742/appengine-cloud-sql-performance-issue-taking-too-much-time-to-process-the-reque#> >> >> on my django project i am using app-engine with cloud sql, the problem i >> am facing a significant performance issue , app-engine is taking too much >> time to process the request like 3,4 minutes, when i looked at the trace >> its showing a latency below 1.5 seconds which was expected. my app-engine >> is of F1 instance class Min Idle Instances, Max Idle Instances and Max >> Concurrent Requests as auto, and cloud sql is a High memory machines with >> 2CPU 13GB memory. >> >> and its happening even if i am the only user in the project, i don't know >> where i am going wrong, how can i improve the perfomance? >> > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/bb7054d2-0bf5-48aa-87d4-74a55409bde6%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
