Performance

[Sébastien Nicouleau]

I'm working on a project where I would have 100 Million lines, I'm considering the google cloud sql solution, in terms of performance compared to a postgress database on a vm compute engine from google?

By reading the various articles on sql nail, it is necessary to use the proxy-sql, what about the performance of this little piece of application, risk of bottleneck?

[Jinjun (Cloud Platform Support)]

In terms of performance, Cloud SQL and database on GCE VM should be close. It mainly depends on how large the instance you plan to use. Cloud SQL does have many of its own benefits. It's worth checking this FAQ page and this Stackoverflow post when you make your decision.

For connection to Cloud SQL, you can either use Cloud SQL Proxy or direct IP connection. As long as you're using connection pooling in Proxy connection, the performance should be close to direct connection. Check https://github.com/GoogleCloudPlatform/cloudsql-proxy/issues/87, the post on Jul 28, 2017.