PivotGridOptionsData.DirectDataAccessInClientMode Property

Gets or sets whether the calculation engine bypasses the creation of temporary storage for source data.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v19.2.Core.dll

Declaration

C#

[DefaultValue(false)]
public bool DirectDataAccessInClientMode { get; set; }

VB.NET

<DefaultValue(False)>
Public Property DirectDataAccessInClientMode As Boolean

Property Value

Type	Default	Description
Boolean	**false**	:True, to not upload source data to temporary storage; otherwise, false.”

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to DirectDataAccessInClientMode
WinForms Controls	PivotGridControl	.OptionsData.DirectDataAccessInClientMode
ASP.NET Controls and MVC Extensions	ASPxPivotGrid	.OptionsData.DirectDataAccessInClientMode
	MVCxPivotGrid	.OptionsData.DirectDataAccessInClientMode
	PivotGridSettings	.OptionsData.DirectDataAccessInClientMode
Reporting	XRPivotGrid	.OptionsData.DirectDataAccessInClientMode

Remarks

The data engine loads data to local in-memory storage. This local storage is optimized for frequent calculations with typed data sets and guarantees data integrity. Some large data sets, however, may require too large a memory footprint (which can, in turn, slow down an application).

When the DirectDataAccessInClientMode option is enabled, the calculation engine does not upload source data to temporary storage. This avoids performance degradation in Client mode when working with large volumes of data (and when frequent re-calculations are unnecessary).

Note

This option is not available in PivotDataProcessingEngine.Legacy mode.

The following code demonstrates how to enable the option:

C#

pivotGridControl1.OptionsData.DirectDataAccessInClientMode = true;

VB.NET

pivotGridControl1.OptionsData.DirectDataAccessInClientMode = True