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