SAP Knowledge Base Article - Public

2470848 - resultMaxRowAllowed parameter increase causes performance issues

Symptom

The goal of this KBA is to explain about the performance implications that can be caused by increasing the "resultMaxRowAllowed" parameter to a very high value.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Learning admin >
  2. System Administration >
  3. Configuration >
  4. System Configuration >
  5. Open the Search configuration >
  6. amend the resultMaxRowAllowed parameter value (default is 2000).

Resolution

  • The default value (2000) is the standard and is considered as the best practice for the "resultMaxRowAllowed" parameter.

  • Note that if a higher value is provided, there are chances of issues like delay in getting the file, timeout issues on the application end, etc., as the data has to be fetched from the database. This is a decision that needs to be carefully taken by the Learning admin taking into consideration all the mentioned aspects.

  • If the parameter is modified, to compare the data of the result, compare it with the Account Data report.

  • Another option is to use the PRD tool to create a custom report for this requirement and use this to fetch the required data from the database. For more information on the PRD tool, check: Using Plateau Report Designer and 2171592 - Process to enable the use of Plateau Report Designer (PRD)

See Also

2171592 - Process to enable the use of Plateau Report Designer (PRD)

Plateau Report Designer

Keywords

resultMaxRowAllowed, Download Search Results, excel, performance, implication, parameter, 2000, delay, timeout, time, out, issue, application, server, database, prd, tool, user, users , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , LOD-SF-LMS-REP , Reporting Data , How To

Product

SAP SuccessFactors Learning all versions