AnsweredAssumed Answered

Which is faster: Calculation Field or Script-calculated value entered into Field?

Question asked by user28222 on Mar 1, 2017
Latest reply on Mar 9, 2017 by William-Porter

Hi everyone,

 

Assuming the layout is complex with many conditional formatting going on, and wanting to reduce the time it takes to render the layout, I want to know which option is faster(and if so, if magnitude of the speed difference is significant or negligible ):

 

Option A:  Field is defined as unstored calculation field in the data table.

Option B: Field is defined as numeric/text field in the data table, and I use scripts to calculate desired value and then use Set Field command.

(Assume I have to a lot of the above)

 

Any advise would be greatly appreciated - FM rocks, but I am kinda stuck with these speed bumps which make an impact on the client experience.

 

Thank you.

Outcomes