Limiting records for test runs | Community
Skip to main content
H
HarshalTe
Level 3
February 7, 2020
Solved

Limiting records for test runs

  • February 7, 2020
  • 3 replies
  • 3266 views

Hiya,

 

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?

 

-wALF

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Craig_Thonis

Hello wALF,

 

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.

 

Regards,

Craig

3 replies

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity Advisor
Community Advisor
February 10, 2020

Hi,

 

You really want to spin up at least one non-prod env.

If queries are running slowly, first place to check is indexes: join, filter, sort columns. Beyond that, check the hardware sizing of the db, if vm bump its cpu/memory allocation as appropriate.

Failing all that, use nms:seedMember to host test records, with the caveat this will require significant manual effort or some light scripting/Excel to generate.

 

Thanks,

-Jon

    Craig_Thonis
    Adobe Employee
    Craig_ThonisAdobe EmployeeAccepted solution
    Adobe Employee
    February 14, 2020

    Hello wALF,

     

    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.

     

    Regards,

    Craig

      H
      HarshalTeAuthor
      Level 3
      February 26, 2020

      Hi Jon & Craig,

       

      Totally agree that we need a pre-prod region and that no testing/build activity should be performed on Prod.  But that's how we are, without a pre-prod region.  Given the situation we're in (and in general, for all other customers too), don't you think having the ability to limit records flowing from 1 box to the other, be helpful?

       

      As for saving the interim results, trust me, we have always encouraged users to not make use of this but end users are end users 🙂 

       

      -wALF

       

      Terms & ConditionsAccessibility statement

      Loading footer...