performance issue -application takes more time to get data from database table

General
, , , , , ,
1

Hello All,

Application report definition taking too much time to load but the same query from SQL developer works faster.

When i do DB trace, it shows high time in preparedStatement in SQL.

Any help would be highly appriciated.

2

@VenkatKanneti please log a support incident via the MSP and let us know the INC id here so we can help track the issue.

3

@MarijeSchillern Thanks, Issue got resolved after removing pzInsKey from Report definition, now data loading fine.

4

Hi @MarijeSchillern like venkat said if we have pzinskey in report definition will it load slowly? if it Yes then could you please explain me to understand..

Thanks.

5

@VenkatKanneti

We have couple of approaches to debug this:

  • check if the report is pulling any non optimized while querying.
  • We can add pagination if there are more records.
  • Check on maximum records to display.
  • Check on joins , there might be some table joins which are taking time to fetch data
  • Last we can also create a database query Index if needed to increase the performance.