I'm doing some work whereby I need to copy around 15 variables from a data table to a warehouse/reporting table. This is to reduce lag time when running the report as there are many summaries involved over many columns.
The question I'm looking for help on is regarding the speed of the script. Currently, I set 15 variables, change layout, set 15 fields, end.
Is there a way that the whole 'set variable x 15, change layout, set field x15' routine could be made faster?
The script itself is really basic, literally 15 rows of variable setting, change a layout, 15 rows of field setting. The variables themselves are based on summary calculations from a found set of around 400 records on average.
Thanks in advance