CarePointS Member since 2013 3 posts
Posted: 11 months ago
Last activity: 10 months 4 weeks ago

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
Share this page LinkedIn