I have a few of time-intensive rules like this that run on a regular basis. These rules look about like this:
- Perform a very small query on an MDA table.
- Perform a very large query on a Salesforce table.
- Left merge MDA->Salesforce
- Perform some action.
On most days, step #1 returns no records. But Step #2 is still executed regardless. The resulting left merge is zero records, and no actions are performed.
It would be great if there was a way to tell the rule to abort if step #1 returns no records. One of these rules in our org takes roughly 20 minutes to execute (thanks to step #2), and 90% of the time, there are no actions completed. But I have to leave it running “just in case”. If we had the ability to abort the rule, it would take a mere 10 seconds to execute instead.
I wonder how much rule processing time could be saved, across all tenants, if something like this were possible.