I use 15 sheets (Products, Orders, Customers, Items, Locations,… etc.) with each having average 20 columns on my Google Spreadsheet database. I used to have reasonable sync (2-5 seconds) time but recently it is around 10-17 seconds which is really annoying.
When I look at the performance tab, virtual columns take too much time. These virtual colums are auto-generated by Appsheet when I referenced tables to each other.
I know I can disable them, however, I want them. When I open Customers view, I would like see and be able to jump all other stuff related to customer (such as Contacts, Open Orders etc.)
Is there a way to not to compute such ‘auto-generated’ virtual columns while syncing and keep them some sort of delayed sync? becaue may be just need to edit Customer name and no need to wait to compute all virtual colums (tables) related to (referenced to) that customer.
Thanks in advance.