Archive process for Interaction History data slowing performance
With Pega Marketing 7.11 on Pega 7.1.6, the query involving Interaction History (IH) is taking time to fetch the data, leading to poor performance.
Users want to know the recommended archive process for IH and which indexes to reapply to reduce the data size and improve interaction time.
Steps to Reproduce
A software use or operation error
The housekeeping of Interaction History should be performed at regular intervals by archiving or purging old data.
Use the sample scripts for archiving and purging the Interaction History (IH) table data that were introduced in Pega 7.1.9 .
You can use the sample scripts with Pega 7.1.6 because there are no structural changes to Interaction History between these releases.
For more information, see the Pega 7.1.9 Help topic, Sample scripts for archiving and purging.
Published November 29, 2018 - Updated October 8, 2020
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.