Question
4
Replies
63
Views
Accenture
Posted: March 22, 2020
Last activity: April 26, 2020
Generating Report Definition considering performance criteria in Production
In DPage I have one post processing activity where I am calling one report which will get all results like
- What are the cases we worked upon,
- Report should be based on certain conditions like SLA, if SLA is less than deadline.
- Like that I have couple of more sorting criteria
- I have 200+ thousand records
For better performance, logic should be done at one go. How?
Thanks,
***Edited by Moderator: Pallavi to update platform capability tags***
I'm not sure what your question is here, can you elaborate?
It sounds like you will have ~100K rows sorted by multiple columns in your report. Are you asking how best to do that from a performance standpoint?
If so, a lot of that will happen in the database, not in Pega. In order to get the query to run efficiently, the indexes on the table(s) must be set up correctly.
Depending on the nature of the data, you might want to consider setting up a database view that is pre-populated ahead of time.