Can i replace a virtual column with a regular column (with a few actions).?

[Gokul1]

I have 4  virtual columns in a single table  that are related to different tables. Its slowing down the app.  Can i replace this virtual column with a physical column(with specific actions)?

i'm unable to make a physical column work using enumlist.

[baba_sawane]

What is the use of theses virtual columns ?

[Gokul1]

these are ref columns. eg. i wanna replace my "Related OUTPUT_ITEMs By LOT_NUMBER_ID" column which has  the formula "REF_ROWS("OUTPUT_ITEM", "LOT_NUMBER_ID")" with a physical column.

[baba_sawane]

Hi, Goku thanks for answering. Please use the "reply" button to make the thread more readable.

Can you detail what is slow in your app, is that the sync process or the navigation between menus ? 

You can check in your performance analyzer

[scott192]

I am guessing that your app is taking a long time to start up and sync?

Do not consider removing the Ref_Rows formula as these are needed to make your app work like a proper database.  Instead, take a look into the Audit History of the App and look for the App Sync lines.  You are able to dive into this section and will see timings for how long it takes appsheet to load each of the tables in your app.  Investigate the slow loading tables to see why they take so long.

[Gokul1]

I struggling to understand these reports

[baba_sawane · Accepted solution]

Highlighted in red is the sync time of each data updates. Look at every sync time of this report, and if one is particularly high, look further into the data using the little button at right.

You can then see exactly which table is using extensive calculation and slowing down the sync time.

Of course, that is if the sync time is the issue there. If the app is slow and sync time is not the issue but the navigation, you need to filter your data with security filters as too much rows are displayed at once.