Hi all,
I have a process that I want to run, for the amounts of data/records on an array, BUT, I want to control the number of instances it runs each time.
For example, I have 20k records but I want the process to execute 30 each time.
Discussion posts and replies are publicly visible
mrios0001 said:For example, I have 20k records but I want the process to execute 30 each time.
There are multiple strategies, one way is to query batchsize 30 in a!queryRecordType() and kickoff Start Process Smart Service for each of the 30 instances and a way to check if the processes are complete and kickoff next batch (One of the ways to check if the kickoff subprocesses are completed using send/receive message nodes).
Kicking off lot of processes this way is not recommended/not a best practice. There are some cases it is fine, like initial application setup/data migration etc.
Please refer to similar use case
If you are still looking for a potential solution you could look into the Transaction Manager located in the App Market. This App also gives you the ability to adjust/tune batch sizes/cycle time to obtain better performance and to load balance batches of through your application servers. Another benefit is that you can throttle the batches so that they don't overload your servers.
community.appian.com/.../transaction-manager