Question
DXC
IN
Last activity: 26 Nov 2019 15:27 EST
Does Listview Malfunctioning the query - Caused Slowness
Listview rule is defined with two filters to fetch data from DB table and display the results in UI. This list view was generating a query that was missing the indexed column “pxCoverInsKey” in the select query and only considering the non-indexed parameter “pyStatusWork” resulting in slower response.
WHERE "PC0".pxObjClass = ? AND ( ( "PC0".PYSTATUSWORK LIKE ? ) )
Suspecting that Listview rule is malfunctioning the query and caused the issue. what are the possibilities caused the issue?
Planning to introduce Report definition rule with Listview rule, is there any chance the same situation will arise with report definition rule?
Compared to Listview rule Is there any performance improvement with report definition rule?
Pegasystems Inc.
US
Which Pega Release you are using?
In Pega 7, list view is essentially deprecated and does not fully meet HTML5 standards. We highly recommend converting it to Report definition.
https://community.pega.com/sites/default/files/help_v83/procomhelpmain.htm
https://collaborate.pega.com/discussion/performance-issue-opening-and-downloading-list-view-report
DXC
IN
Thanks Susan for the response. We are using PEGA 7.1.7.
We are planning to implement the same with report definition. My only concern that Does report definition malfunctioning the query? Does report definition will provide performance improvement?
Pegasystems Inc.
US
Just to confirm, you had a list view with an OOTB getContent activity, where even though the filter conditions included pxCoverInsKey, it was not included in the WHERE clause? If this is the case, it sounds like a bug.
The query generation code has changed substantially for report definitions relative to list views. There is no longer a getContent activity involved. All query generation has moved into the engine code. While I can't predict whether a specific report will have a bug in its query generation, I would be very surprised if the same bug showed up.