1 Reply Latest reply on Nov 8, 2014 4:38 PM by schamblee

    Script critique needed



      Script critique needed


      Script novice here.

      The script I wrote in the image works for what I wanted it to do but it seemed very slow (for my usually fast machine).  I only have 1800 records and it seems to take 5-7 seconds to execute this script.





        • 1. Re: Script critique needed

          Looping records can be slow.  I don't see a need for a loop.  You really didn't give enough details about your database for me to give you the best answer.

          The process that set the Amt_trans field could also set the Amt_join_db at the same time or you could make the Amt_Join_Db field a calculation field.

          If these fields are related then why copy the data to another field?