Synchronization takes too long

My app functions as a pallet checker in a logistics company. I managed to significantly reduce the scanning time between boxes, which was one of the app’s problems. However, now I have a problem with synchronization time. My view, which I use to see the checked pallets, is updated automatically. It retrieves the data from my checking view to organize the checked pallets view, but this takes too long, at least 10 seconds for each record. When I check a pallet with 60 boxes, it takes several minutes to see if the pallet is complete or if there are any problems. Can you help me reduce the synchronization time?

Hey,

Hope you’re keeping well.

It sounds like the delay is coming from how AppSheet is recalculating and syncing data between your “checking” view and the “checked pallets” view. In AppSheet, sync performance depends heavily on how much data is being read/written and whether calculations are happening client-side or via virtual columns. Try reducing the number of virtual columns that depend on large datasets, and move complex logic into precomputed fields in your source (e.g., Google Sheets, BigQuery) so AppSheet only retrieves final values. Also, enable Delta Sync in AppSheet’s app settings so only changed rows are fetched, and review the table’s “Store content for offline use” and “Sync on start” options to avoid unnecessary reloads. Optimizing these will significantly cut down the multi-minute syncs you’re seeing.

Thanks and regards,
Taz

1 Like