Adobe Campaign Standard - Workflow - Query Aggregated Function Performance

[Cloudnifier]

I have a requirement on journey below:

1. Import Invoice Header Level Data into ACS including (Invoice ID, Amount, Discount, Coupon Discount etc)
2. Setup a ACS workflow to query profile which meet the requirement based on invoice data, e.g. Query Profile who total spending > $1200 in past 30 days.
3. Workflow will trigger daily to find out the profile who fulfill the requirement and save as audience list.

I would like to know the feasbility on ACS's performance this kind of journey which the total invoice volume is around 30-40 million. Can the ACS workflow work fine on this volume?

[ramon_bisswanger]

Hi,

the volume should be fine as long as the proper indexes are used in the data model

The query may run few minutes but as it's a background job, I don't see an issue with that

[Sukrity_Wadhwa · Accepted solution]

Hi @Cloudnifier,

This question was addressed in one of our Adobe Campaign Community Q&A Coffee Breaks on Apr 21st at 8am PT with Scott Segrin, Eric Knee, David Loyd, Peter Mancuso from Adobe Campaign Enterprise Architecture Team. 

You can check the response here: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic/adobe-campaign-community-q-a... 

Feel free to reach out on the same thread in case you have any follow up questions.

Thanks!