Defect HC-9089
Excessive calls to determine catentry type for price rules
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0209911 | V9.1.3.0 | 9.1.11.0 |
Observed behavior
The query SELECT CATENTTYPE_ID FROM CATENTRY WHERE CATENTRY_ID=? is being executed repeatedly for price rule evaluation.
Expected behavior
The query results should have been cached to avoid repeated execution of the SQL.
Resolution
PriceRuleElementCmdImpl.getCatentryTypeId() has been updated with a cache of the catenttype_id value to avoid unnecessary database calls.