BuyLog In
Ticket T1285191
Visible to All Users

PivotGrid for Web Forms - Handling 1.3 million records

created 12 days ago

Hi,

I’m currently working with a dataset of approximately 3 to 3.5 million rows retrieved from SQL, which I need to load into a pivot grid. However, the query fails after running for some time.

As a test, I tried loading a smaller subset of up to 1.5 million rows, but the same issue persists. The error indicates an out-of-memory exception during grid loading.

Given that each row contains only a few fields, should the pivot grid theoretically support this volume of data? If not, could you recommend efficient solutions or alternative approaches for handling such large datasets?

I would greatly appreciate any insights or suggestions.

Thanks,

Sign in to comment on this post

Answers approved by DevExpress Support

created 12 days ago

Hi,

For your usage scenario, I recommend considering either the OLAP Data Source or Database Server Mode.

For a detailed comparison and guidance on selecting the appropriate mode based on your data volume, please refer to the following help topic: Pivot Grid Performance.

I hope you find this information helpful. Let me know if you have further questions.

Regards,
Alessandro

    Show previous comments (2)
    LZ LZ
    Lawrence Zilko 3 days ago

      Hi Support,

      Thank you for the reply.

      I need this functionality to work with the OLAP Data Source, as it is essential for meeting user requirements along with improved Pivot Grid performance.

      I kindly request that you arrange for someone from the technical support team who can assist in resolving this issue, as it is impacting the user experience and is a matter of urgency.

      Please arrange a support call with the technical team at the earliest convenience.

      Thanks,

      Alessandro (DevExpress Support) 2 days ago

        Hi,

        The OLAP Mode has its own advantages and drawbacks. Before adopting this mode, it's important to ensure that its specific behaviors align with your project requirements. The limitations associated with OLAP Mode are inherent to its architecture and cannot be bypassed for technical reasons.
        If these limitations are not acceptable, the only viable options are either to proceed with OLAP Mode while accounting for its constraints or to continue using the regular binding mode.
        Regarding live support — this option is not available. Please refer to the following article for more details: Limitations On DevExpress Support Services. The most effective way to resolve technical questions is through our Support Center, which remains our primary support channel. If you have additional questions, feel free to share more details so we can assist you more effectively.

        LZ LZ
        Lawrence Zilko 2 days ago

          Hi Support,

          Initially, we implemented the Database Server Mode; however, we encountered significant performance issues even with just 1.4 million records. Based on your recommendation, we then switched to using the OLAP Data Source to improve performance.

          At this stage, I would appreciate your technical guidance on either of the following:

          1. How we can resolve the performance issues with Database Server Mode, or
          2. How to enable the required functionalities (such as advanced filtering, clear filter, etc.) with the OLAP Data Source.

          Unfortunately, I cannot proceed without these functionalities, as they are essential for our users.

          Kindly assist with a workable solution at your earliest convenience.

          Thank you.

          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.