How to improve loading and scrolling performance in PivotGrid?
23 Oct 20191 minute to read
The performance of the PivotGrid control can be improved by enabling the on-demand calculation on the value cells and by disabling the auto-sizing option. This refreshes the calculation only while loading or scrolling the PivotGrid control. This can be achieved by using EnableOnDemandCalculations
and AutoSizeOption
properties of PivotGrid control.
Please refer the below code snippet.
public MainWindow()
{
InitializeComponent();
pivotGrid.AutoSizeOption = GridAutoSizeOption.None;
pivotGrid.PivotEngine.EnableOnDemandCalculations = true;
}