Question
Report Definition not fetching all the records from the table without pagination
Hi Team,
We need to query around 80,000 of data from DB and process those records alos export the data into excel as well, we have used Report Definition to fetch the values, we are able to fetch the entire records when we use Pagination enabled, but for our legacy application needs an entire data result set to copy into another page reference to process the data, we are not able to fetch more than 10,000 records without pagination. We are getting timed out ,same for export to excel as well more than 10,000 records count to load we are getting timed out.
We have updated the Reports Settings(DesignerStudio->Reports-Setting) and in Report Definition Data Access tab as well.
Maximum number of rows to retrieve 50000
Maximum elapsed time (in seconds) for database query 300
Please provide any suggestion for the above need, we are using Pega 7.4 version.
Thanks,
Dhilip
I hope all the columns are optimized, which will help you with better performance.
Include all descendant classes that can be unchecked, if not relevant.
Exclude any formatting configured in the report columns
Another alternative (preferably not recommended) is to create a DB view and configure Report on the same