Thanks for providing a little more information. 3 to 4 minutes is indeed strange but I cannot reproduce this latency. For testing, I created 100,000 rows of text columns. Then sent over 100 requests to an App Engine instance that retrieves a single row (always the same one) and updates it. I've had no issues getting these rows updated in under 1 or 2 seconds per request albeit with some contention issues since always reading/writing to the same row.
To reiterate, I would need a lot more context to help your identify the source of the bottleneck. Have you tried using Stackdriver Trace to identify what is taking the bulk of time to respond to a request? Is it when processing the request, connecting to the DB, reading the row, writing to the row, closing the connection, compiling the response, any of the above? 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/9e69f7cf-09b1-4d5b-88b8-72f4cbd0296b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
