Support Article
Performance degrades when importing the product ZIP file
SA-79078
Summary
Performance degrades when importing the product ZIP file.
Error Messages
PEGA0005 alerts regarding the table pr_index_reference.
Steps to Reproduce
Import a product file.
Root Cause
The system performed a full table scan before it added a record. This took about four minutes per record. This was because the index was missing for the primary key - pzinskey.
Resolution
As a local-change, create the index on the column - pzinskey.
Published August 15, 2019 - 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.