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