I wanted to check with the community to see if any other app developers are facing a delay in syncing with Google Sheets data. I created this app somewhere around mid May with absolutely no issues in it with regard to sync with google sheet. But recently it sometimes takes up to 20-30 mins and multiple refresh/restart to app for the data to be updated on the front end for the user.
Anyone else also facing issues like this? Can someone guide me to any kind of sync logs that could be studied to understand this behaviour?
It has about 10,000 rows currently. The behaviour is very unpredictable. about 70% of the times things are very smooth. the rest 30% of times there are sync issues like
Delayed Sync
Two copies of same row (In Google Sheet) seen on the app
I am unable to generalize the issue or find any pattern as to exactly when the sync issues start. Are there any diagnostic tools I can use?
I am happy to shift to Glide Big table if there is any easy way to switch to it.
You can right click on any table in the Data view, and click “Analyze Performance” to see how much time a column takes to load. That might provide some good insights for you.
Currently there’s no easy way to switch from an external data source to Glide Table/Glide Big Tables, though there might be something like that in the future.
If the issue persists, please talk to the support team.