We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl number of rows limitation

Thread ID:

Created:

Updated:

Platform:

Replies:

32006 Jul 19,2005 05:16 PM Jun 18,2014 04:40 AM Windows Forms 5
loading
Tags: Grouping
Erik Huynh
Asked On July 19, 2005 05:16 PM

I am using Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl to display our huge database of over 2 million rows. I don''t know if the Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl can control/display such a large number of rows. Please help me ASAP. Thanks a lot.

Administrator [Syncfusion]
Replied On July 19, 2005 06:28 PM

Hi Erik, Do you want to sort/categorize these data or do you just want to display them in the grid? To just display them there is a VirtualMode support that we provided with the latest patches. If you want to group them there also performance optimizations that allow you to handle larger amount of data but I am not sure if grouping 2 million records is fast enough. Best is if you just try it out. But don''t try it with the latest 3.2.x public release. It will not be able to handle that amount of data. You first need to get a patch from us. We can provide a patch if you open a direct-trac incident. Or you can also wait a couple days for the 3.3 service pack release. Should be out soon. Stefan >I am using Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl to display our huge database of over 2 million rows. I don''t know if the Syncfusion.Windows.Forms.Grid.Grouping.GridGroupingControl can control/display such a large number of rows. >Please help me ASAP. >Thanks a lot.

Erik Huynh
Replied On August 24, 2005 07:27 PM

The previous answer is great. Now, I have the same limitation question for Syncfusion.Windows.Forms.Grid.GridDataBoundGrid can it control/display such a large number of rows? (Like over 2 million rows) What is the maximum number of rows that Syncfusion.Windows.Forms.Grid.GridDataBoundGrid can display, and for how many fields?

Administrator [Syncfusion]
Replied On August 25, 2005 03:53 AM

Handling 2M records is not so much limited by the GridataBoundGrid as by what technology you use to obtain the 2M records from where you have them stored. So, if you intend to use ADO.NET datasets/datatables, then they and your hardware will be the major players in what performance might see. It is straight-forward to see what you can expect. Create a Datatable with a certain number of rows/columns and set it to be the grid''s DataSource. Here is a little sample. The sample is set to display 400,000 but you can change it to what you want. For my 1G laptop, it took about 1.5 min to create the 2M row datatable and about 2 secs for the grid to display it after it was created. http://www.syncfusion.com/Support/user/uploads/GDBG_31a22bcf.zip

Leo Rakita
Replied On June 17, 2014 03:39 PM

I am using a 32 bit Win 7 system running Syncfusion 9.3.0.61. I was wondering what is the maximum number of rows the syncfusion grid element can support. 

Neelakandan Kannan [Syncfusion]
Replied On June 18, 2014 04:40 AM

Hi Leo,

 

Thank you for your interest in Syncfusion products.

 

We have already updated solution to this reported scenario.

 

Please refer the below forum,

 

http://www.syncfusion.com/support/forums/windowsforms/gridcontrol/116846

 

Please let me know if you have any concern.

 

Regards,

Neelakandan


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;