Monday, September 9, 2013

Re: Cloud SQL is slow (?)

Hi Andrew

The SQL Console is intended for simple admin and reporting functions and is not intended for production loads.
If you are connecting from a GAE application you should expect latencies around 1ms.

J


On Mon, Sep 9, 2013 at 9:11 AM, Andrew <andrey.xf@gmail.com> wrote:
I have Cloud SQL D32 instance (the largest one) and it takes 30 ms to query a table with two records. Querying table with 500 records takes 75 ms. Execution time is reported by web SQL Prompt (judging by a screenshot listed below it's the time taken by DB server to execute query and not the whole roundtrip). I think it's unreasonable. Amazon RDS performs all these operations in less than 1 ms. Does anyone have any ideas why it might be? Or what am I missing?

Here's a screenshot: http://grab.by/q044

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/790b1b65-7f0c-4242-9495-63b06ed2dd07%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.



--
Joe Faith | Product Manager | Google Cloud

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/CAHNz2%3D_6fuBBsWDdePfppdGyA6rwwFORxyBVAdy1jD9RV1tp7w%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment