When to Use Large Data Mode

There is no precise limit as to when to start using Large Data mode. This depends on multiple factors:

  • PPM Server hardware configuration

    PPM Server hardware configuration impacts on template rendering time.

  • PPM Server heap memory

    More memory means that larger amount of data can be inserted in Template mode without facing memory issues.

  • Excel template complexity

    If you use lots of formatting on the data you insert in the template, this will result in a much bigger XLSX file and more memory usage.

Overall, tests show that Large Data mode should be considered when more than 10,000 rows of data can be inserted in the Excel report.