I have a script that replaces 6 fields' contents, each with a specific list of 51, by evaluating a calculation from another table. The calculations use 'Let' to set calculation level variables from the result of an SQL calc.
Because of the number of calcs, it takes 2-3 seconds to complete the script so I am pondering how to speed it up. For 4 of the fields, 1 of the 'Let' variables will be the same, so:
a) Can I set a script level variable early the in script and pass this into the 'Let' calculation?
b) Will such rearrangements make much difference to 'script speed'?