I have a reporting workflow feeding into webmerge which does the following:
- 1st of each month collects all device info for reporting.
- Begins loop 1 which loops through each deviceId.
- Within loop 1 i have an additional loop this cycles through 28 / 30 or 31 iterations depending on the past months length and for each day it collects the sum of 1 attribute and the max of another attribute and writes to two arrays.
- The arrays are sent along with device info to webmerge for reporting at each iteration of loop 1 ( for each device).
I’ve been running this with 16 devices total and I’m at around 49 seconds execution time for the workflow. Seems the configuration of the embedded loops and the iteration length is taking quite a while.
Just after some suggestions as to a better way to approach this as needs to handle a lot more devices in the future.