SOLVED
How to reduce workflow run time?
Dear Community
I have created query activity but It will take around 9 minutes to run this activity. Can you please tell, Is there any possible ways to reduce run time of this activity.
Activity is Query.
Schemas: Recipient, Account (custom schema), broadlog schemas
filter condition:
product IDs form account table. around 3 products
segment codes: 4 codes
1 Accepted Solution
Correct answer by
Hi @SatyanarayanaCh ,
In query, select targeting dimension as recipients and filtering dimension as broadlog schema and in filtering conditions - apply only the broadlog conditions,
And after this Query result, have a split activity and in that apply other conditions of recipient and custom account table.
Correct answer by
Hi @SatyanarayanaCh ,
In query, select targeting dimension as recipients and filtering dimension as broadlog schema and in filtering conditions - apply only the broadlog conditions,
And after this Query result, have a split activity and in that apply other conditions of recipient and custom account table.
Related Conversations
