BuyLog In
Ticket S133758
Visible to All Users

Support the Server Mode in the pivot grid

created 15 years ago

I am making an application based on XtraPivotGrid. I have no OLAP service installed. It works well. But I am worrying about the scale of the data source, for some times the data source is too big to cause XtraPivotGrid very slow.
So I think server mode support could be very helpful for such a situation. I read a few posts and some have the similar requirement.
If you don't think so, can you give some suggestions to avoid the performance problem?
Thank you in advance,
Ying LI

Show previous comments (1)
M M
Mr Ying LI 15 years ago
    1. I am using other databases instead of SQL Server.
    2. Although in most situations, maybe local mode is faster than server mode, but at least server mode is more stable than local mode when we deal with large data set.
    DevExpress Support Team 15 years ago

      Hello Li,

      1. Analysis Services can fetch data from datasources other than SQL Server, using OleDb.
      2. The PivotGrid requires a complete datasource grouping and aggregation while the XtraGrid may work fine with just a portion of data, since it doesn't summarize it. The PivotGrid requires a "preaggregated" storage of all possible sums in the dataset, to work fast. Analysis Services provides such kind of storage.
        Thanks,
        Ivan
      M M
      Mr Ying LI 15 years ago

        Thnaks

        Sign in to comment on this post

        Answers approved by DevExpress Support

        created 10 years ago (modified 10 years ago)

        We have implemented the functionality described in this ticket. It will be included in our next update(s).

        Please check back and leave a comment to this response to let us know whether or not this solution addresses your concerns.

        Additional information:

        Starting with v14.2, the pivot grid supports server-side data processing and allows you to use large data sets as pivot grid data sources. In this mode, the pivot grid performs data-aware operations on the database server side. To enable Server Mode, use the following components depending on the target platform:
        -  ASP.Net - EntityServerModeDataSource and LinqServerModeDataSource;
        -  Windows Forms - EntityServerModeSource and LinqServerModeSource;
        -  WPF - EntityServerModeDataSource and LinqServerModeDataSource.

          Comments (1)
          GM GM
          Gustavo Marzioni 10 years ago

            Great news!

            Sign in to comment on this post

            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.