IF THEN vs. CASE statments

[JerrySalem]

Hi all,

I just inherited a database to work on.

In it are some calc fields that have multiple, nested, if then statements (about 35 each).

These calcs are unstored and take about a minute to calculate when I want to display the results on the layout.

I am trying to optimize the calcs, is there any speed difference in FMP(6.0) when evaluating multiple nested if then statements versus evaluating a single multi line case statement?

Opinions all?

TIA

Jerry.

[-Queue-]

Here's one such discussion on it.