Question

3
Replies
26
Views
Close popover
CarePoint Support Group (CarePointS)
CSC

CSC
IN
CarePointS Member since 2013 3 posts
CSC
Posted: November 24, 2019
Last activity: November 26, 2019
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