How to reduce workflow run time? | Community
Skip to main content
S
SatyanarayanaCh
April 16, 2025
Solved

How to reduce workflow run time?

  • April 16, 2025
  • 1 reply
  • 355 views

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

 

 

 

 

Best answer by ParthaSarathy

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.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
April 16, 2025

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~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...