Why the default values of “Maximum number of rows to retrieve” , “Maximum number of rows to retrieve”, “Maximum number of rows for export” and “Maximum elapsed time in seconds for export” are 500, 30, 1000 and 30 ( fixed default value) respectively?
- Pega will not recommend to load more than 500 results data in user requester session. All the data which is getting retrieved by using report definition will be getting stored in user session cache, if we are loading more results and storing in user session cache then performance will get impact. Instead of loading more data we can pull 500 data at a same time, we can use pagination in UI also which will help in optimizing the performance.
- Maximum elapsed time is to make sure for pulling the data from database system is not taking more time and to make sure query was more optimized and system able to pull the data with less amount of default time.