BuyLog In
Ticket T1285191
Visible to All Users

PivotGrid for Web Forms - Handling 1.3 million records

created 5 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 5 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

    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.