Improving Performance of Local MySQL and SQL Server Databases with AppSheet

[T_I_Phong]

Hi AppSheet Community,

I’m currently using three databases in parallel with my AppSheet application: Google Cloud MySQL, local MySQL, and local SQL Server. I’ve noticed that the Google Cloud MySQL (with the lowest configuration) performs significantly faster in terms of read/write speed and connectivity compared to my local databases, which are 3-5 times slower. I have two questions to help improve the performance of my local databases:

1. For Google Cloud MySQL, I’ve added the IP address provided by AppSheet to allow connectivity. Do I need to add the AppSheet IP address to my local MySQL and SQL Server databases as well? (I haven’t done this yet for the local databases.)
2. What configurations or optimizations should I apply to my local MySQL and SQL Server databases to improve their read/write performance with AppSheet? Any suggestions or best practices would be greatly appreciated.

Thank you for your help!

[Marc_Dillon]

1. Only if your local database only allows connections from a whitelist.

I'd guess the performance issue could be one (or both) of two things; read/write performance, and network latency.

You can probably test if it's the first by sending several large CRUD operations to each database, the same to each, and see the processing time. How do the specs of your local database server compare to the GCloud config?

If it's not that, then it's maybe the network. How is your internet connection? Where are you located? It's possible that the distance and connection between Appsheet servers and GCloud database servers is optimized beyond what you'd be able to achieve with a local db server. They are owned by the same company afterall.