Flow Designer Question :- Action "Do the following,until "

[pratapdalai]

HI All,

I have the following example:

I have three tables, and whenever a record is added to or modified in Table 1, a flow is started with the instruction to "Do the Following, until Record Count is 1."

It will check Table 2 to see if a certain entry has been created. If not, it will wait five minutes before performing the lookup again. My question is: Will there be any system performance issues if records on Table 2 are never created? similar to any application-level thread deadlock problem.
Tell me what you think.

Than You,

Pratap

[Sandeep Rajput]

@pratapdalai Initially the performance issues will be negligible but you will start to notice the issues once Table 1 will start to have more and more records. A flow context will get associated with the creation of each record and if these flows are not completing and keep on waiting to check records in every 5 minutes on table 2 then you will have a queue full of such flow contexts which keep on triggering every 5 minutes.

I recommend having a onBefore Insert business rule on Table 2 which will eliminate the need of running flow in every 5 minutes.

[pratapdalai]

Thanks Sandeep