Speeding up Calculations

[ejpvi]

Greetings,

I have a feeling I can find a workaround for this... but at this point, I am curious what others have done.

I have a series of calculations that must be performed to get an ultimate result.

The issue is, it is about 9 calculation fields deep.. and each subsequent calculated fields, relies on a previous field.

So by the ninth calculation... all 8 other calcs must be evaluated before it can perform the ninth.

This is causing major slow downs by the end of all this.

It handles the first 6 with ease.. but once I start getting near the end... it is a snails pace.

I know this has to do with indexing... and since these are from related tables... it won't allow indexing.

I have tried a couple of different way to do these calcs.. but in the end.. I still have to perform them in a certain order.

One idea was to write a script, that temporarily stores the calc in an indexed variable.. then perform all of the calcs from there... but I don't really see how that would speed things up.

If you have several calcs like this.. does anyone know any tricks to speed this up... or force minimal indexing?

[comment]

It's hard to say anything with practically no details, but do you really need the interim fields?