Dataverse Benchmark: Calculated Column vs Formula Column


In Dataverse, there are two similar data types called Calculated Columns and Formula Columns. The author wanted to compare the performance between the two. They created a table with two attributes: Qty (Number) and Price (Money). They then created a Calculated Column and a Formula Column for benchmarking purposes. They used a .NET 6 Console app with BenchmarkDotNet for benchmarking. The results showed that the Formula Column was faster than the Calculated Column. However, the performance can depend on the environment and the complexity of the formula used. The author suggests waiting for the Formula Column to become generally available for production use.


Article 19m

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time