I have noticed some erratic data-sync behaviour when making bulk changes to the data in my GSheets, and was wondering if what I am seeing is normal and expected behaviour.
The app in question has about 25 GSheets in the back-end, and around 2500 rows in total across all sheets. Due to the nature of the app, on a weekly basis I purge the data on about a third of the sheets, and repopulate them with fresh data. (The sheet header rows are left intact during the purge, so that my relations/lookups/etc don’t break). During each purge, around 600-700 rows of data will be removed and replaced.
What I have noticed is that more often than not when Glide re-syncs after a purge there will be lots of gaps in the data - both when viewed via the data editor, and the app. Generally one or more columns in several sheets will be completely empty. It always sorts itself out after a while, but this can take several re-syncs and refreshes of the app before everything is back to normal.
So I have two questions:
- Is this normal and expected behaviour?
- If it is, are there any techniques I can adopt to improve the sync behaviour when I’m making these bulk changes?