Performance issue - Application takes more time to get work object details data
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
Keep up to date on this post and subscribe to comments