4 Replies Latest reply on Oct 9, 2014 12:43 PM by Timothy Bentley

    Reduce time to complete a script

    sccardais

      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?