Optimiser used in ACS

[Rut7]

Hi All,

I was curious to find out the optimizer type in ACS, any help will be useful :

• Which type of optimizer is used in ACS ?
• Can we change optimizer settings for import/export workflows for better workflow performance ?
• Best practices for workflows to comply with existing optimizer in ACS ?

Thanks,

Rutuja Kelkar

https://www.linkedin.com/in/rutuja-kelkar/

https://twitter.com/therutujakelkar

[acc_acs · Accepted solution]

Hi @Rut7 

Thanks for your question!

In this link you will find best practice tips for workflows (import/export, duplicating wkfs, execution, etc).

https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/workflow...

Regards

[acc_acs]

Hi @Rut7 

Another good tip to improve performance is to check the queries that exist in your workflow.
For example. Choose a workflow for this. Identify the tables and fields that are used in these queries.
Then check if these fields that are used in queries in this workflow, if these fields are indexed.
If not, in ACS, go to "Administration / Development / Custom Resources" and select the table.
On the "Data Structure" Tab, go to Index and click on "Add Index" and add the table field that is used in your workflow query.
This will provide a performance improvement in your workflows.

Regards