Defect HC-12327
Prepared statements are created and closed many times in the CatalogGroup mediator.
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0253397 | V8.0.4.24 | 8.0.4.29 |
Observed behavior
Prepared statements are created and closed many times in the CatalogGroup mediator leading to performance issues.
Expected behavior
There should be a more efficient means of managing the prepared statements for better performance.
Resolution
The code has been updated to reuse the prepared statement rather than re-create repeatedly.