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.

ASP.NET Performance

Thread ID:





25899 Mar 9,2005 09:38 AM Mar 9,2005 01:54 PM Windows Forms 3
Tags: Grouping
Asked On March 9, 2005 09:38 AM

We have a table with approx 11 million rows by 10 columns wide (with various length fields). Will Essesntial Grouping be able to cope with this and display records using ASP.NET?

Administrator [Syncfusion]
Replied On March 9, 2005 12:24 PM

Bob, Assuming you don''t want all the million rows on the client page at the same time, if you specify some filter settings that would reduce the number of rows displayed (to 100 or so) then the performance would be acceptable. -Praveen

Replied On March 9, 2005 12:56 PM

Hi, Thanks for the response. I wouldn''t necessarily need to show all of the rows at once but I would need to be able to show the summary info. i.e. If I have all of my 10 columns, the user will need to be able to pick at least one of those columns (possible even up to 5 or 6) and be able to group by them. I will then only need to show the summary results. My main concern is that the essential grouping component would need to load all of these rows in order to do the grouping and wondered if someone knew if it would handle this situation? Thanks Bob

Administrator [Syncfusion]
Replied On March 9, 2005 01:54 PM

Hi Bob, 10 million rows might be too much too handle. You could test drive such scenario with the GroupingPerf example that ships with the Windows Forms Grouping Grid. It lets you specify the number of records and whether to group and categorize them. Once you go above 500,000 or a million records the memory consumption might become an issue. One way to be able to display more rows would be to fall back to the plain grouping engine without grid and nested table support. In the samples that ship with the plain grouping engine you will notice that you can set a property "RecordsAsDisplayElements" = true. This will cut down memory usage for the grouping engine and you should be able to load it with a couple million records. 11 million might still be too much, though. Stefan


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.

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.