Tuning Business Rules and Workflows

the following sections describe how to tune business rules and workflows to maximize performance implementing these practices can significantly improve overall system performance and reduce deadlocks and timeouts caused by the workflow engine disabling inactive business rules docid\ brn7kbflz c8 04dohx38disabling inactive workflows docid\ brn7kbflz c8 04dohx38deleting workflow tables docid\ brn7kbflz c8 04dohx38validating email addresses in notification workflows docid\ brn7kbflz c8 04dohx38 disabling inactive business rules review all active business rules if a business rule is no longer used, disable it by removing its trigger and updating the rule description to disabled disabling inactive workflows whenever a workflow is triggered, the system adds it to the event queue where it waits to be processed reducing the number of workflows waiting to be processed in the event queue improves performance review all active workflows if a workflow is not used, disable it and update is description to disabled deleting workflow tables it is not uncommon for workflow history tables to contain hundreds of thousands of records workflow instance tables can also contain large numbers of records deleting workflow history and instance tables prevents the workflow engine from having to query them deleting workflow history and instance tables can significantly improve event table performance for details about how to deleting tables, see deleting inactive tables and records docid\ re1ppmikg jkpplm58rp4 we recommend that you delete workflow tables on a regular basis (such as one or more times per week, if feasible) validating email addresses in notification workflows if a notification workflow containing an invalid email address is triggered, event queue resources are wasted while the invalid email address is evaluated and processed to prevent this situation, add a condition to notification workflows so that email addresses are validated before the workflow is triggered