I am using a cloud sql instance (db-n1-standard-1
1vCPU, 3.75 GB)
for one of my projects.

I noticed that the queries are very slow.

For example, a SELECT query on an empty table (SELECT * from customer) takes 0.03 sec, while on my Macbook Pro Retina 2013 MAMP local database takes 0.00057 sec.

My region is set to ‘Europe-west1’ (Belgium) and I am in Italy.

To test I connected cloud sql db to Mysql Workbench on my macbook.

How can I increase performance? So it is really unusable.

For information the database engine is InnoDB.

Thanks in advance! 🙂