I'm working on sync time improvements on my a...

(Nick Haschka) #1

I’m working on sync time improvements on my app. I’ve noticed that the current bottleneck is computation of virtual columns automatically generated by appsheet for Related References (Ref_Rows(x,y)). I don’t actually need these fields for anything I’m doing with the app, but there’s no way to get rid of them. Is there a way to get the speed improvement of not having to compute them?

I’ve thought of hiding them, computing them from smaller slices of the table (all tables are GSheets), but it’s not readily apparent if either of these approaches are running any faster. Would appreciate any tips that might help me speed up computation on these fields so I can speed up my overall sync times.

(Aleksi Alkio) #2

The only way you can get rid of them totally is that you don’t use ref fields in your column structure. If you use Enum field for example, there would not be any Refrows to calclulate.