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

    Script critique needed

    amtrakpdx

      Title

      Script critique needed

      Post

      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.

      Thoughts?

      TIA

       

      Screen_Shot_2014-11-08_at_4.14.34_PM.png

        • 1. Re: Script critique needed
          schamblee

          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?