Question

3
Replies
26
Views
CarePoint Support Group (CarePointS)
CSC

CSC
IN
CarePointS Member since 2013 3 posts
CSC
Posted: November 24, 2019
Last activity: November 26, 2019
Posted: 24 Nov 2019 12:30 EST
Last activity: 26 Nov 2019 15:27 EST
Closed

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?

System Administration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.