Slow performance while performing Search operation
SummaryUser is facing below issues:
Issue 1: When searching for results and fetching it from Database. It is taking lot of time to fetch the results and display on the current screen.
As user proceeds to later environments the wait time is gradually increasing.
Issue 2: When user clicks on Checkbox to select or deselect an item refresh issue is observed.
Error MessagesNot Applicable
Steps to Reproduce1.On click(event) of Search, activity with two refresh sections gets triggered.
2. In activity, using RDB-list Stored Procedure is getting called and results are fetched through Obj-browse.
Root CauseAn issue in the custom application database tables where indexes on columns are not created and querying the data by using those columns.
This is time consuming and impacts performance.
ResolutionPerform the following local-change:
Create the indexes on columns which used for querying, so that query result will be quick and increases the performance.
Published May 15, 2017 - Updated May 31, 2017