Ticket Q370781
Visible to All Users

How to improve dashboard performance and decrease loading time

created 12 years ago (modified 11 years ago)

Hi,
I did some experimenting with the Dashboard component using the online docs and my own (SQL Server 2008) database. Based on my experience I have some questions:

  1. The component just stops with an out of memory error when querying a 700.000 records tables during the initial load determining the fields. why do not something like a 'top 1' , 'where 1=0' or whatever modification so the fields list can be retrieved in sub-second times?
  2. If the problem mentioned at 1) gets solved will we then run into the problem that the query times out when retrieving the data for manipulation in (e.g.) a pivotgrid? If so, what/who is the intended audience of this functionality (taking the number of records it can handle as a measure)?
    regards
    Martin

Answers approved by DevExpress Support

created 12 years ago (modified 12 years ago)

Hi, Martin
Thank you for your question. The appearance of a dashboard depends on its underlying data, so the Dashboard Designer should load all the data from the data source. That's why we do not use Top or Where clauses in the Designer. You can do this yourself by writing a custom SQL query in the Data Source Designer (for example, use top 10000), but this will affect content of the dashboard.
Also, the current version of the Dashboard does all calculations on the client side. It loads all data in memory to process it.
So, to make calculations take a reasonable time, you need to significantly reduce the number of loaded rows. At this moment, you can do this in the following ways:

  1. Reduce a datetime range for data, for example, create a view that will select last several months, weeks or days, depending on your data.
  2. Aggregate your data to larger pieces - for example, in the AdventureWors database, you can group sales by weeks.
  3. Create an external filter control (like a list box or a range filter) for a dashboard and load data programmatically using its selection. See the Change data in Dashboard issue for more details.
    I have also duplicated this issue to the Data Binding - Provide the server-side data processing mode (Server Mode) suggestion. You will receive a notification when the server mode is implemented. This mode should resolve problems caused by loading a huge amount of data…
    Show previous comments (4)
    DevExpress Support Team 12 years ago

      This issue is duplicated to the Data Binding - Provide the server-side data processing mode (Server Mode) suggestion. You will receive a notification when the server mode is implemented. This mode should resolve problems caused by loading a huge amount of data.

        me too.

        GM GM
        Gustavo Marzioni 11 years ago

          I agree with Martin, even the top n feature (or async mode) would be great for design mode, where all editing tasks are very, very slow with large datasets

          Disclaimer: The information provided on DevExpress.com and affiliated web properties (including the DevExpress Support Center) is provided "as is" without warranty of any kind. Developer Express Inc disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.

          Confidential Information: Developer Express Inc does not wish to receive, will not act to procure, nor will it solicit, confidential or proprietary materials and information from you through the DevExpress Support Center or its web properties. Any and all materials or information divulged during chats, email communications, online discussions, Support Center tickets, or made available to Developer Express Inc in any manner will be deemed NOT to be confidential by Developer Express Inc. Please refer to the DevExpress.com Website Terms of Use for more information in this regard.