Support Article
Archive process for Interaction History data slowing performance
Summary
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.
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
A software use or operation error
The housekeeping of Interaction History should be performed at regular intervals by archiving or purging old data.
Resolution
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.
Tags:
Published November 29, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.