Good day Anoop, I hope your testing is going well. To help test latency, I would strongly suggest you consider the following:
- What the average size of a client request payload sent to your App Engine instances? - How many of these requests are you seeing per second or minute during high latency periods? - What is the size of the payload sent to your Cloud SQL instance? - How long does it take to insert that new data into a given SQL table(s)? - How long does it take to connect to and disconnect from the SQL instance? Answers to the above questions may shed some light on various possible bottlenecks. As previously suggested, handling large amounts of data at once may hinder performance as a large single insert requires linear execution. Whereas inserting multiple smaller units of data lends itself quite well to concurrent execution allowing each request handler to complete sooner to handle new incoming requests. I hope the questions above are helpful and look forward to your findings. 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/7f4e33d7-d822-4c2f-acbd-2f54cd3e372a%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
