Defect HC-14216
Performance issue due to SQL query with no parameter markers
Software
| Customer case | Applies to | Corrected in |
|---|---|---|
| CS0298733 | V9.1.9.0 | 9.1.10.0 |
Observed behavior
A SQL query to CTXDATA does not contain parameter markers, impacting performance.
Expected behavior
Parameter markers should be used in SQL queries wherever possible.
Resolution
The code was updated to replace the static query with parameter markers, improving performance.