You are viewing limited content. For full access, please sign in.

Question

Question

use anonymous user multiple times - timer frequency question

asked on May 15, 2018

I am working on a proof of concept for a way to use anonymous users multiple times in a solution. It requires 2 separate processes. 

What it all boils down to is how frequently I should check to see if a change has been made. In other words, I have 2 separate processes writing to the same database. While one process is editing & writing to the database, the other is looping through a workflow database check to see if a variable have been changed and it should continue. 

The key question is:  what is a reasonable amount of times to perform the workflow database check. I am estimating 200-300 active records occurring simultaneously. Ideally, the more frequently I can run the check, the better. 

Once a day is a little infrequent. I am liking the twice a day as a happy medium. How much of a negative impact would that cause? Is there any reason not to make it 3 times a day?

 

Thanks

0 0

Replies

replied on May 15, 2018

I would need more info. What outcome are you expecting once the process completes?

0 0
replied on May 16, 2018 Show version history

The outcome is that an external SQL database is updated by 2 separate processes. Simple enough. There are 3 steps in the parent process where an anonymous user needs to add/update data. Whenever one of those steps is reached, an email is sent to the user. From a separate Forms, they would have to select which record they want to update. (Since this is an internal process, authentication is not a big concern)

The user adds/updates the data and it is written back to the same database via workflow. Meanwhile the parent process is running a looping workflow that queries if a change has been made in the database. If it has, it will route to the next consecutive approver. I received some feedback from my VAR on this. We are going to check 3 times a day.  

 

The only outcome I am interested in is the routing where an anonymous user can update a previous record they submitted. Thanks

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.