Dashboard Performance With Large Data Sources

• Mar 20, 2024
• 4 minutes to read

This topic lists recommendations you can use to improve performance and reduce memory consumption. You may need to use these techniques when a dashboard is bound to a large collection of objects and has performance issues.

Limit the Number of Objects Loaded in the Dashboard Designer

Note

ASP.NET Core Blazor applications do not support this technique.

If you do not need to load the entire data set to the Dashboard Designer, you can use the DashboardDataProvider.TopReturnedRecordsInDesigner property to limit the number of loaded objects. To access the DashboardDataProvider object, use the static DashboardsModule.DataProvider property. The following example demonstrates how to set the TopReturnedRecordsInDesigner property in the platform-agnostic module‘s constructor:

File: MySolution.Module\Module.cs (Module.vb).

C#

using DevExpress.ExpressApp.Dashboards;
// ...
public sealed partial class MySolutionModule : ModuleBase {
    // ...
    public MySolutionModule() {
        // ...
        DashboardsModule.DataProvider.TopReturnedRecordsInDesigner = 100;
    }
    // ...
}

VB.NET

Imports DevExpress.ExpressApp.Dashboards
' ...
Partial Public NotInheritable Class MySolutionModule
    Inherits ModuleBase
    ' ...
    Public Sub New()
        ' ...
        DashboardsModule.DataProvider.TopReturnedRecordsInDesigner = 100
    End Sub
    ' ...
End Class

Disable Automatic Updates in the WinForms Dashboard Designer

When you perform a data-aware operation in the WinForms Dashboard Designer, the dashboard sends a query to a data source and updates itself automatically according to the returned data. It can take a significant amount of time to update the dashboard according to each change. In this case, you can disable automatic updates and update the dashboard manually when needed. For more information, refer to the following help topic: Automatic and Manual Updates.

Filter Data

When you filter the dashboard data source, the criteria is applied server side. This allows you to reduce the amount of loaded data. Refer to the following help topics for instructions on how to apply filters:

Windows Forms

• Filtering
• Passing Parameter Values

ASP.NET Web Forms and ASP.NET Core Blazor

• Filter Data Sources
• Dashboard Parameters
• Supply Dashboard Parameters (ASP.NET Core Blazor)

Use DataView Mode

Note

Entity Framework Core does not support DataView mode.

Windows Forms and ASP.NET Web Forms

Follow the steps below to retrieve a lightweight read-only list of data records instead of loading the collection of persistent objects.

1. Inherit from the DashboardDataProvider class and override its CreateViewService method:

   File: MySolution.Module\CustomDashboardDataProvider.cs (.vb).

   C#

   using DevExpress.DashboardCommon;
   using DevExpress.ExpressApp.Dashboards;
   using DevExpress.Persistent.Base;
   // ...
   public class CustomDashboardDataProvider : DashboardDataProvider {
       protected override IObjectDataSourceCustomFillService CreateViewService(IDashboardData dashboardData) {
           if(dashboardData.Title == "Sales Overview") {
               return new DashboardViewDataSourceFillService();
           }
           return base.CreateViewService(dashboardData);
       }
   }
   

   VB.NET

   Imports DevExpress.DashboardCommon
   Imports DevExpress.ExpressApp.Dashboards
   Imports DevExpress.Persistent.Base
   ' ...
   Public Class CustomDashboardDataProvider
       Inherits DashboardDataProvider
       Protected Overrides Function CreateViewService(ByVal dashboardData As IDashboardData) As IObjectDataSourceCustomFillService
           If dashboardData.Title = "Sales Overview" Then
               Return New DashboardViewDataSourceFillService()
           End If
           Return MyBase.CreateViewService(dashboardData)
       End Function
   End Class
   

2. Use the static DashboardsModule.DataProvider property to register the custom dashboard data provider in the platform-agnostic module‘s constructor:

   File: MySolution.Module\Module.cs (Module.vb).

   C#

   using DevExpress.ExpressApp.Dashboards;
   // ...
   public sealed partial class MySolutionModule : ModuleBase {
       // ...
       public MySolutionModule() {
           // ...
           DashboardsModule.DataProvider = new CustomDashboardDataProvider();
       }
       // ...
   }
   

   VB.NET

   Imports DevExpress.ExpressApp.Dashboards
   ' ...
   Partial Public NotInheritable Class MySolutionModule
       Inherits ModuleBase
       ' ...
       Public Sub New()
           ' ...
           DashboardsModule.DataProvider = New CustomDashboardDataProvider()
       End Sub
       ' ...
   End Class
   

ASP.NET Core Blazor

Note

You cannot use DataView mode in the following situations:

• when you design dashboards; only enable DataView mode if you do not plan to edit your dashboards;
• when you use cross-data source filtering.

In ASP.NET Core Blazor applications, you cannot enable DataView mode for a specific dashboard, but you can do it globally for all dashboards. See the following code snippet for an example:

File: MySolution.Blazor.Server\Startup.cs.

C#

using DevExpress.ExpressApp.Dashboards.Blazor.Services;
// ...
public class Startup {
    // ...
    public void ConfigureServices(IServiceCollection services) {
        // ...
        services.AddXaf(Configuration, builder => {
            // ...
            builder.Modules
                .AddDashboards(options => {
                    // ...
                    options.SetupDashboardConfigurator = (dashboardConfigurator, serviceProvider) => {
                        dashboardConfigurator.SetObjectDataSourceCustomFillService(new BlazorDashboardViewDataSourceFillService(serviceProvider));
                    };
                })
                // ...
        }
        // ...
    }
    // ...
}

Use the SQL Data Source

You can use SQL Data Source instead of XAF Object Data Source when you create a dashboard. This data source allows you to access data directly and bypass Object Space and the ORM data layer. In most cases, this improves performance. The following help topic demonstrates how to use this data source in ASP.NET Core Blazor applications: Use SQL Data Sources (ASP.NET Core Blazor).

Note the following limitations when you use this technique:

• Custom logic implemented in business classes (for example, calculated properties) does not execute.
• Security System rules are ignored and your data is not secured.
• The Module does not save credentials for non-XAF data sources inside dashboards due to security reasons. The DatabaseCredentialsSavingBehavior property allows you to change this behavior. Alternatively, you can pass credentials for such data sources manually, as demonstrated in the following article: How to: Pass Credentials to the Dashboards Module when You Use External Data Sources).