Skip to main content
Level 1
Apr 16, 2025 3:23 PM UTC
Solved

How to reduce workflow run time?

Dear Community

@parthasarathy 

 

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

 

 

 

 

ParthaSarathy
ParthaSarathyAccepted solution
Community Advisor
Apr 16, 2025 3:51 PM UTC

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.

~  ParthaSarathy S

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
Apr 16, 2025 3:51 PM UTC

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.

Translate
~  ParthaSarathy S