I know this was asked multiple times with variable context. I have gone through the SF documentation regarding Process Builder & Workflow limits & different use cases but I'm still unable to make a decision to migrate Workflows to Processbuilder as Process builder doesn't go well with triggers.
My Use Case: I have a trigger on Opportunity which handles complex business logic. There are few active Opportunity workflow rules with field updates/emails & active process builder which also has field updates. The criteria used for workflow & Process builder are different.
I'm trying to optimize different WFs & migrate them into a Single process builder with multiple criteria & criteria specific actions which include record updates.
As I have multiple criteria where each criteria has its own actions that perform field updates. How will this impact the governor limits. Does each criteria specific update consumes 1 dml & 1 Soql?
Example: I'm combining all the workflows into single process as shown below.
-One PB_Process per Opportunity Criteria 1 --> Action(Update Opp record) Criteria 2 ---> Action(Update Opp Record) Criteria 3 ----> Action(Update 3 Opp Record) Criteria 4 ----> Action(Email Notification)
As per the order of execution and per transaction limits, does Process builder hit more limits than all workflows combined. Like what would be the dml & SOQL count in both cases.