Solved: Syncing Very Slow for SQL data connections - Page 2

PhilTeare · 11-26-2024 01:27 AM

Since the error for database connections last Friday, the data sync has been running very slowly for our app, which uses a SQL database in Azure.

Here's the thread about last friday's issue:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Bug-Adding-tables-form-MySQL-database/m-p/83705...

I've reached out to appsheet support, they say they are aware and working on the slow syncing problem:

We are working on completely resolving the issue at our end. However, it might be possible that it will be back to normal some time.

For us, sometimes the sync is just very slow, but more often than not syncing fails, and often gives random error messages too (that are incorrect). I'm wondering if anyone else has been having this issue? Especially with SQL or other external databases?

I'm a touch nervous as we are 4 days in now and there's no clear roadmap for when things will be working again. Would anyone have experience of such happening before, and how long it took before there was a fix?

AleksiAlkio

Are you still seeing the same slowness? I have production apps using Azure SQL and I haven't seen such behavior with those apps. One of the biggest app has 50 tables and huge amount of data & functionalities and the sync time in reality is about 4..5 secs.

In general speaking, when using real databases, one of the biggest things to concider are security filters. They need to be set properly so they are converted to a SQL query. When AppSheet is doing this, the AS server will convert your formula as a parameter list which is limited to 999 (The limit is actually coming from MS something like 2000 parameters). You can check how the app has converted the security filter from the Performance Analyzer. It shows something like this..

{"TablePath":"Table=1499152386__[dbo].[Samples]","DataFilter":"RestaurantID Equals Bc6b056ab , Deleted GreaterThan 11/25/2024 00:00:00","RowsRead":"2","ColumnsRead":"13"}

View solution in original post