Question

8
Replies
220
Views
John Paul Raja Christu Raja (JohnPaulRaja,C)
PerseusX Incorporated
Consultant
PerseusX Incorporated
US
JohnPaulRaja,C Member since 2011 262 posts
PerseusX Incorporated
Posted: August 20, 2019
Last activity: April 17, 2020
Posted: 20 Aug 2019 22:54 EDT
Last activity: 17 Apr 2020 14:25 EDT
Closed

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.