so we get lets say 200k records from db and each record needs to be processed which involves calling multiple downstreams. the thing it has to be complete in lets say in 15-30 mins max. I am thinking of using parent child workflow but want to get opinion here.
am thinking of using parent child workflow but want to get opinion here.
Yes, using child workflows per record to process set of activities for this record is good way to approach use case.
Given the max pending child workflow limit per parent (2K) you will need to nest child workflows to achieve full parallelism, or if you need to throttle child workflow executions at some limit can consider sliding window approach in parent workflow - see sample here