Conditional format better than unstored calc.?

[GC GYM]

Left over from earlier FM versions, I have some fields with unstored calcs used to conditionally highlight records/fields.

I saw somewhere that unstored calcs slow down your solution.

Would I be wise to delete theseunstored calc fields and just conditionally format the relevant fields/objects now that CF is available in FM9?

Edited November 8, 2008 by Guest

[comment]

Unstored calculations do not slow down your solution. What slows down your solution is the evaluation of these calculations.

If you have a list layout showing 30 records, and two of the fields shown are unstored calculations, then 60 evaluations need to be performed before the layout can be rendered. The same 60 evaluations will have to performed if those two fields are changed to use conditional formatting. So I doubt you'll see a significant difference speedwise.

However, moving these calculations into the presentation layer where they belong and reducing the clutter in the data layer is a benefit on its own.

[GC GYM]

Great. Thanks for that Comment. -)