Question
MBAFC
CN
Last activity: 6 Jun 2017 13:58 EDT
Auto complete could not work very well. （prepared statement had bad performance）
The auto complete control on the screen could not work correctly since the source Report definition run with had bad performance.
When check the sql trace found the prepared Statement had bad performance.
Does some body know the reason for the bad performance for use prepared statement on Pega.
More details please refer to the Trace information and sql trace document.
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
US
Hi TianS327,
Looking at your trace you have a view joining with 2 other tables. I would suggest that you take the query and the parameter values in the trace and run the query manually in SQLPlus or some other tool directly against the database. Getting an explain plan / analysis of the DB execution will likely point you to the slowness in your query.