SA-32545

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.