Skip to main content

Question

 Venkat k (VenkatKanneti) OCBC
OCBC
IN
VenkatKanneti Member since 2016 4 posts
OCBC
Posted: Aug 14, 2023
Last activity: Nov 21, 2023
Posted: 14 Aug 2023 23:27 EDT
Last activity: 21 Nov 2023 1:08 EST
Solved

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

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.

 

 

 

 

***Edited by Moderator Marije to add Capability tags***
To see attachments, please log in.
Pega Platform 8.7.4 Data Integration Performance Reporting Financial Services Team Lead

  • Reply
Posted: 10 months ago
Posted: 20 Nov 2023 20:05 EST
Dhanasekar Chellamuthu (DhanasekarC0202) Tekclan Software Solutions Associate software Engineer
Tekclan Software Solutions
IN

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.

To see attachments, please log in.
Posted: 10 months ago
Posted: 21 Nov 2023 1:08 EST
Ankush Agrawal (Ankush Agrawal) Truviq Systems Senior consultant
Truviq Systems
NL

@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. 
To see attachments, please log in.

Related content:

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice