we have one old workflow which receives a parameter, query recipients table, update one flag and send notification via continuous delivery. Recently, there were around 400 simultaneous invokes with different parameter and we noticed that AC waiting to query all 400 recipients and update flag and then send notification. This causing a big delay in notifying customers.
Any idea how to ensure that process query first recipient, update flag, send notification and then start again with new recipient? I am open for ideas how to completely redesign this workflow based on your good practice.