Solved: How to Speed Up Sync Time - Page 2

finkployd · 02-27-2023 12:16 AM

Hi!

I have a tools inspection function that i made which has a sum of 7 thousands over items. These are distributed amongst 6 teams and roughly 1 thousand over items per team that need to be checked.

So they will have to check one by one, every single one of them. And Ive made a function to pass or fail these inspections as shown in the picture above.

So the question arises with the syncing time. I noticed when I checked the first hundred, the syncing icons will have 100 numbers. and it takes awhile for it to go down (synced).

So you can imagine how long it takes to inspect ALL of THEM.

How do I fix this?

I cant let them wait 1 hour to ensure every item is synced.

Marc_Dillon

If you're making a hundred changes, you need to sync everyone of those 100 changes. There's no getting around that.

One option for your situation would be to build a bulk-selector, where the user can open a form on another table, select a single value for pass or fail, then select multiple items from the dropdown, that all either pass or fail. This record entry can be used to generate the data however you need in the end. You can then use an API Bot to make all of the changes on the server-side instead of having to force the user to sync them all. Although this doesn't work if you need immediate visible changes on the user side.

------

Or leave it as it is, have them check every single item, then when they're done just put the device down and let it sync while they go do something else. Perhaps they need a dedicated device for this task?

-------

You're also using the new desktop preview mode, which has been reported as being a lot slower than legacy view modes.

---------

You can certainly try to get an Appsheet support person to suggest improvements in your app, but that's not really what they are for, so I wouldn't be surprised if they refuse. You're better off hiring someone on Upwork or Fiverr to do a performance review.

View solution in original post