I added a 'days elapsed' calculation and it appeared my transition speed between records (using a script that employs NextRecord, PrevRecord, etc ...) suffered about a 50% increase.

I removed the calc and things are 'normal' again.

Is this to be expected with Calc fields? This one is nothing fancy - just one date subtracted from another. The data is not stored, as the dates are in two seperate tables.

Might the slowdown be attributed to the data in different tables?

Thanks in advance - just hoping to see what others have experienced to gage what goes on over here.

Since posting this originally, I experimented adding the field to the other table, and also turned indexing OFF. No effects on the speed.

Neither table is an occurrance of the other.

Edited December 9, 200817 yr by Guest

It doesnt really seem like there should be that great of an issue. I dont think it should take that long to recalc it. Are they straight equijoins (=)?