Question

Wait condition performance impact?

Workflow

Updated November 26, 2018

asked on December 18, 2014

Hello,

Is there any limit to the number of wait conditions that can be active at any one time?

Also, is there any performance impact on having lots of wait conditions active for long periods of time?

We have some business processes that could benefit from multiple wait conditions but I want to make sure that having 100's or even 1,000's of active wait conditions that may not be satisfied for several months or even a year or more won't provide a negative impact on performance or anything else that would be a cause for concern.

Thanks in advance.

Eric

0 0

Answer

SELECTED ANSWER

replied on December 18, 2014

There is no limit. Waiting activities are saved to the SQL database and conditions are reevaluated when changes are made to the entry. The subscriber retrieves and evaluates the conditions for a given entry, it does not reevaluate all conditions looking for ones matching the entry.

I expect you're going to have lots of entries in the waiting state with a few conditions on each one rather than a very low number of entries with hundreds of conditions on each one. So the condition evaluation shouldn't really cause a performance issue in the Subscriber.

The only impact you may see is in the size of the database since these instances would be kept around until completed, but not enough to worry about it.

0 0

replied on November 13, 2018 • Show version history

Are the waiting activities stored on the SQL server as a stored procedure? Or is it a column, etc.? @████████, if you could expand on this a little it would be helpful in troubleshooting an issue we recently had with out SQL server.

Thanks!

0 0

Replies

replied on December 19, 2014

Thank you Miruna. Yes, your insight is correct.

We will have many documents that have one or maybe a few wait conditions on each. The wait condition will be very helpful in some of our workflows and I am using them now for some documents but the condition is usually satisfied within 24 hours. I just wanted to be sure that having several 1000 documents sitting out there with pending wait conditions that could take several months to satisfy would not create a bottleneck somewhere. Sounds like we'll be ok.

Thanks again!

0 0

You are not allowed to follow up in this post.

Question

Question

Wait condition performance impact?

Answer

Replies

Sign in to reply to this post.