Reduce time to complete a script
I have a script that creates a found set of records through a series of 10 Find and Omit steps that are applied to almost 70,000 records. The script takes about 2 minutes to complete and I'd like to speed it up if possible.
One of the script steps identifies records if the value in a calculation field with Unstored results (DaysSinceLastSurvey) is less than a certain value (≤365). Based on Script Debugger, it appears that this step takes the longest. I suspect it's because the calculation needs to be performed on each record individually. Is there a way to speed this up?