Defect HC-2973

CatalogEntry dataload performance problem

Software

Customer case Applies to Corrected in
CS0111398 V8.0.4.0 8.0.4.25

Observed behavior

The catalog entry loading operation can take several times longer than in the previous release.

Expected behavior

A poorly performing query was introduced in V8 that mistakenly processed all rows in the input file. A large number of rows in the input file, coupled with a large number of entries in the CATGPENREL table can make the loading process extremely long.

Resolution

The query was removed and additional logic was used to take its place bringing the performance back to comparable with the previous release.