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!