We're hosted on ACC v7 build 8894 with Postgres as our DB. Since we don't have a pre-prod region, our end users build campaign workflows directly on Prod and play/test with it. The testing on Prod results in large data sets being sent from one activity to the other, multiple running until they get the desired target list, saving interim run results . Instead, we were thinking if they can limit these test runs on a subset of the larger data, it would result in faster workflow execution whilst still be able to give the end users enough confidence with the target list generated.
D'ya guys happen to have any thoughts around this or any easier way to achieve this?
Have to agree entirely with Wodnicki here as testing directly in production is against recommended best practices. Additionally using the Keep Interim Results is also not recommended as it retains temp data within the database and can cause performance issues. That setting should only be used on a limited basis to troubleshoot a workflow, then turned off.