[google-appengine] Why is appengine so slow communicating with CloudSQL?

2014-05-09 Thread Myles Bostwick
Hi All,

I hope this is the right place for this question.

I am seeing some drastic differences in speed between development and 
production on a service call that goes to a CloudSQL backend.

I ran three tests for comparison, each test ran 2 things:
1. Varied number of rows fetched from the database, 125, 250, 500, 1000 and 
2000, where a typical row size is on the order of 30 bytes
2. Ran each row count 20 times to get a sampling

The three test environments were:
1. Hosted in appengine connecting to cloudSQL as production will be.
2. Developer mode locally, but connecting to CloudSQL via a static IP.
3. Developer mode locally and connecting to a local VM running MySQL.

Now I would expect a little variance due to the interwebs, but I would 
expect closer to 50 or 100 ms, not 3-4 seconds.

I've attached a graph of the results for anyone interested. (I mostly just 
want to show of my graph)

If anyone has any suggestions on what could be causing such a drastic 
slowdown, I would be very appreciative.

Cheers,

Myles

-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
For more options, visit https://groups.google.com/d/optout.


Re: [google-appengine] Why is appengine so slow communicating with CloudSQL?

2014-05-09 Thread Diego Duclos
This might be me, but I can't see any attachment ?


On Thu, Apr 24, 2014 at 5:46 PM, Myles Bostwick cth...@gmail.com wrote:

 Hi All,

 I hope this is the right place for this question.

 I am seeing some drastic differences in speed between development and
 production on a service call that goes to a CloudSQL backend.

 I ran three tests for comparison, each test ran 2 things:
 1. Varied number of rows fetched from the database, 125, 250, 500, 1000
 and 2000, where a typical row size is on the order of 30 bytes
 2. Ran each row count 20 times to get a sampling

 The three test environments were:
 1. Hosted in appengine connecting to cloudSQL as production will be.
 2. Developer mode locally, but connecting to CloudSQL via a static IP.
 3. Developer mode locally and connecting to a local VM running MySQL.

 Now I would expect a little variance due to the interwebs, but I would
 expect closer to 50 or 100 ms, not 3-4 seconds.

 I've attached a graph of the results for anyone interested. (I mostly just
 want to show of my graph)

 If anyone has any suggestions on what could be causing such a drastic
 slowdown, I would be very appreciative.

 Cheers,

 Myles

 --
 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 google-appengine+unsubscr...@googlegroups.com.
 To post to this group, send email to google-appengine@googlegroups.com.
 Visit this group at http://groups.google.com/group/google-appengine.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 google-appengine+unsubscr...@googlegroups.com.
To post to this group, send email to google-appengine@googlegroups.com.
Visit this group at http://groups.google.com/group/google-appengine.
For more options, visit https://groups.google.com/d/optout.