Calculation Attribute

After you select New Calculation Engine as the pagination engine in a CPT template, the Calculation Attribute function entry will be added to the panel of Template on the menu bar, as shown in the following figure.

This document describes the function and its setting items.

Query Cache

You can tick Query Cache to cache query results, which will apply to subsequent queries and remain valid until the database is updated.

Query Cache can reduce the server load and report loading time.

Multi-Source Optimization

For a report with multiple datasets with numerous dataset associations and data filtering operations, you can select Multi-Source Optimization to optimize filtering performance and improve data retrieval efficiency.

Prioritizing Cursor Pagination

The cursor-based pagination method can improve report performance and extend report compatibility with more data sources.

Optimizing Collapsible Tree Performance

You can click Experimental Function in the upper right corner to open a window where two setting items for optimizing collapsible tree performance are available, as shown in the following figure.

For details about a demonstration example, see Collapsible Tree Setting with the New Calculation Engine.

Optimizing Performance of the Collapsible Tree in a Single Template

You can select Collapsible Tree to optimize the loading of frontend data in the current template, thereby improving the frontend performance of the collapsible tree.

Asynchronous Fetch will appear on the Calculation Attribute page after you select Collapsible Tree. Ticking this option enables the collapsible tree template to fetch data asynchronously, realizing higher data fetching performance. You are advised to tick it when the template contains large volumes of data.

Note: 

Expansion Layer below Asynchronous Fetch allows you to customize the default expansion depth of the collapsible tree. The function is still under development and is not available currently.

Optimizing Performance of Collapsible Trees in All Templates

You can select Collapsible Tree - Async to optimize collapsible tree performance with the Asynchronous Fetch function enabled for all templates in the current project.