I have designed a Nintex Workflow that loops through the items of a repeating section. I'm using Vadim's "Get Forms Repeating Section UDA" to extract form data from the repeating section.
Inside the loop, it does the following actions:
- Query XML action on the multiple lines of text variable received from the UDA. Store output to variables.
- Create Item action to create items in a different list with variables set in step 1 above
- Commit Pending changes action
My repeating section has 40 items on an average. Looping on those 40 items takes about 4 hours to execute.
I know that we have safe looping enabled at the farm level, and that takes about 5 minutes per iteration. And, we cannot disable the safe looping option. My question is whether anyone has any ideas on how to improve the performance of the loop, or an alternative to looping. I had read somewhere that For Each gives better performance and is not bound by the safe looping limitation. Is that true?
I appreciate your thoughts and comments. Thank you!