Support Article
¿¿¿¿¿¿¿Performance of the development environment degrades
SA-82377
Summary
Performance of the development environment degrades.
Error Messages
Not Applicable.
Steps to Reproduce
Unknown.
Root Cause
The PR_DATA_IH_FACT table contains transactional data that expands quickly, increasing the data size.
For more information about this and scripts to purge table for different database, open the below link:
https://community1.pega.com/sites/pdn.pega.com/files/help_v72/dsm/concepts/ih-scripts-con.htm
Resolution
Perform the following local-change:
Delete all data older than one month.
Delete from PEGADATA.PR_DATA_IH_FACT WHERE PXOUTCOMETIME < TO_DATE('2019-05-18', 'YYYY-MM-DD');
Published August 19, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.