Concerning the file download, I have a performance issue with:
- Download attachment A via outlook (a 10mb csv file with 400k rows)
- Download file B through graph API (an excel file with only 100 rows)
If I have a standalone workflow to only download a file through graph API, then the performance is good, usually it takes less than a second and the file B is downloaded.
If I have a standalone workflow to only download the file A via outlook, the performance is also good, it takes sometimes also only a few seconds.
However, if:
- I have one workflow where I download file A first, then file B, then it can easily take up to 15 minutes and still running. Sometimes it takes 3 minutes. Sometimes it never ends. Performance is an issue.
- I have one master workflow and two sub-workflows where I download file A in one sub-workflow, and file B in another, the performance also fluctuates.
If I add even more nodes to extract information from the file, then it's even slower.
Would like some advice how to control the performance.
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
I looked into your issue and it seems like the performance issues might be related to how workflows are loaded sequentially rather than in parallel. You could try using parallel tasks nodes or adjusting the node order to ensure file downloads happen concurrently for better performance. Let me know if this works!