Global field vs. calculated search result

[ljm]

I have a problem with slow search results on a date calculation - today+1 or something like that on a multi-user system. Would it be better to store some of the date calcs as global fields? So it would be calced once and then used quickly in an indexed search?

Also, when this script ran on a repeating field it returned results quickly, but now that I have moved the data into a related file, the return is slow, is there something I should be looking at?

Thank you,

Linda