Large Template Optimization Plan

To avoid problems such as slow loading and excessive memory usage in a system with many large templates, you are advised to set Template Cell Limit,  SQL Execution Period Limit, and Row Quantity Limit Per Dataset on the Template Limit page. If the values of these elements in a template exceed these limits, the template cannot be previewed normally.

If you are unsure about the specific values for template limit setting, you can install the Template Limit Enhancement plugin and use Recommended Settings. Necessary templates with values exceeding the limits set on the Gneral Limitpage can be temporarily placed in Limit Relaxation. You are advised to optimize the templates in Limit Triggering Record or Limit Relaxation with the methods recommended in this document. 

Note:

The function of the Template Limit Enhancement plugin has been built into FineReport V11.0.2 and later versions.

You are advised to use the New Calculation Engine plugin to optimize big data display. 

Note:

New Calculation Engine has been built into FineReport V11.0.

Application Scenario

You may encounter performance issues such as excessive memory usage and slow loading during the  display of templates with large amounts of data.

To solve such issues, FineReport has released the New Calculation Engine plugin and added a new template format, CPTX. This format is mainly designed to enhance the performance of the simple templates involving grouping detail, filtering, and summarizing in large data scenarios, which can significantly improve the loading speed of these templates.

Application Scenario

Exporting large amounts of data will cause pressure on the server, the network transmission, and the database.

To solve the problem, FineReport V11.0 has added the Large Dataset Export function, which allows you to export data based on the dataset results.

Usage Instruction

For details, see JS Large Dataset Export.