AnsweredAssumed Answered

Reduce time to complete a script

Question asked by sccardais on Oct 9, 2014
Latest reply on Oct 9, 2014 by Timothy Bentley

Title

Reduce time to complete a script

Post

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?

 

 

Outcomes