Defect HC-14216

Performance issue due to SQL query with no parameter markers


Customer case Applies to Corrected in
CS0298733 V9.1.9.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.


The code was updated to replace the static query with parameter markers, improving performance.