Virtual columns and performance

A couple questions on virtual columns and its impact on application performance:

  • Are all virtual columns values i.e for every table and every row calculated at app initialization? or is there some “lazy” calculation algorithm which calculates only when the table or row is first accessed?

  • Any best practice recommendations on number of virtual columns for a table or for an app, beyond which performance could be impacted?

Interested in reading any info if this has been discussed elsewhere.

#1 - Virtual Columns are always re-computed for every table and every row during an app sync.
#2 - I believe there is no such practice because it totally depends on the app structure, sheet structure, what’s the app’s aim, the expression(s) you need etc.

1 Like