Currently, my site workflow is struggling with Performance. Because it is using the Query Item action to query more than 5000 items in a list. After that I use the Foreach action to loop those items to do my business. But it always get failed on start (retrying) after I started workflow for 10 mins.
anyone please let me know your solution ? I knew it is the Performance problem where I use to Query Items action. But my business have to query more than 5000 items.
Thanks and regards,