Defect HC-2973
CatalogEntry dataload performance problem
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0111398 | V8.0.4.0 | 9.0.1.14 |
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.