Performance degrades when importing the product ZIP file
Performance degrades when importing the product ZIP file.
PEGA0005 alerts regarding the table pr_index_reference.
Steps to Reproduce
Import a product file.
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.
As a local-change, create the index on the column - pzinskey.
0% found this useful