使用LogicApps缓慢执行具有并行性的三重Foreach会花费40分钟吗? [英] Slow performing triple Foreach with Parallelism taking up 40 minutes with LogicApps?

问题描述

我在产品Foreach中有一个Foreach类别，运行时间为40分钟.基本上，它会为每个类别构建一个HTML表，然后在该类别内将产品与正确的专业化一起放置.

I have a Foreach Category within a Foreach of Products with a run time of 40 minutes. Basically it builds an HTML table for each Category, and within that category it places the Products together with the right Specialization.

当前设置:

• Foreach类别包含5个项目
  • Foreach产品包含300个项目
    • Foreach专业化包含5个项目

    我打开了并行度为10到50的并发控制，但是性能仍然很慢.另外，当我向产品和专业化"添加并行性时，数据未正确排序.知道如何提高性能吗?

    I've turned on Concurrency Control with a Parallelism Degree varying from 10 to 50 but the performance stays slow. Also, when I add parallelism to Products and Specialization the data is not properly sorted. Any idea's how I can boost the performance?

    推荐答案

    在这种情况下，恐怕没有很好的解决方案来实现您的要求.

    For this situation, I'm afraid there isn't a good solution to implement your requirement.

    您提到已启用"并发控制"并行度在10到50之间变化，并导致数据未排序.恐怕您必须更改"并行度"为1，则将对数据进行排序.但这会花费更多时间.节省时间的一种方法是启用"并发控制"并设置"并行度"前五个"每个"中有5个循环，因为第一个"对于每个"循环是为每个类别构建HTML表，因此顺序是否无所谓都没关系(但这也取决于您的要求，您是否关心表的顺序).

    You mentioned that you have enabled "Concurrency Control" with a Parallelism Degree varying from 10 to 50, and it leads to the data is not sorted. I'm afraid you have to change "Degree of Parallelism" to 1, then the data will be sorted. But it will spend much more time. One way to save some time is enable "Concurrency Control" and set "Degree of Parallelism" with 5 for the first "For each" loop, because the first "For each" loop is to build HTML table for each Category, so maybe it doesn't matter if it's out of order(but it also depends on your requirements, do you care the order of tables).

    这篇关于使用LogicApps缓慢执行具有并行性的三重Foreach会花费40分钟吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！