Hey everyone
We are in a bit of a bind with Workflow and records maintenance and I'm hoping someone has a suggestion. Our vendor setup a business process that sends data to Workflow to start a query. This query identifies records to be removed due to them reaching retention limits.
The issue is this is sometimes 20k-40k records per day. Workflow, it seems, has to repeat the query over and over for each record (for each) to delete each one. These workflows are backing up for days and causing general slowness across the org.
We have a very busy environment, but we monitor resources very closely and our servers are never maxed out when this is happening...
Maybe I'm misunderstanding the for each option in Workflow? Maybe there's a "delete entire results" vs a for each? Any help is appreciated.