Question

8
Replies
196
Views
Close popover
John Paul Raja Christu Raja (JohnPaulRaja,C)
Cognizant
Consultant
Cognizant
US
JohnPaulRaja,C Member since 2011 256 posts
Cognizant
Posted: August 20, 2019
Last activity: April 17, 2020

Performance issue - Application takes more time to get work object details data

Hi ,

Application Report definition are takes more time to get the data from pega work and index tables, but when the same database query executed from SQL developer works fast.

Not sure, where the bottleneck.

Report definition using application connection id

when I run in SQL developer, using different id for db connection

Report definition are pointing to exposed column, not blob

Pega version: 7.2.1 , DB: oracle , server: web sphere

System Administration Data Integration