What are you doing with "large data"? if you are loading large amounts of data into ram, processing it and then writing it back to the database it will be slower then smaller transactions. There is a maximum read/write throughput and a max CPU speed on your DB and instances.
On Wednesday, August 3, 2016 at 9:23:52 PM UTC-7, ANOOP M.S wrote: > > No I haven't used Stackdriver , i will use now and update you. In my case > request processing works perfectly with small data, it has a problem when > its working with large data and manipulating it. any limitation for app > engine in handling large amount of data? > > On Thursday, August 4, 2016 at 2:11:03 AM UTC+5:30, Nicholas (Google Cloud > Support) wrote: >> >> 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/ec782708-1417-4fee-9cd4-986aec1d9e86%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
