Improvement proposal for virtual columns

Dear Experts,

Just a thought. For the benefit of the source database in terms of size and normalization, wouldn’t be helpful to have such options in VCs?

  • Calculate once, at row creation
  • Calculate only when the row is edited
  • Calculate always

I think this would be the optimal solution, instead of currently sacrificing database health and size for performance, which is a pity ironically because database size will also have its own impact on performance, though less.

1 4 104
4 REPLIES 4
Top Labels in this Space