Here is two pieces of code to give you a better idea of what I am doing. The first method gives you the data set structure I am using. The Second method is the one that loads most of the data. I call the BeginUpdate and EndUpdate methods around the loop that is calling this method so all the data is inserted between one call to BeginUpdate and EndUpdate. One other thing. The data is added after the grid is initialized. The user selects a day, at any time while the program is running, and that adds about 8000 records at the lowest level each time. There is no imposed limit on how many days a user will have active in the grid at any one time.
By the way. All the data is added via a database. The user cannot insert a record in the grid, only add a new day. The grids are mostly read only except for one column at the lowest level that is used to disable a point from the analysys the program is doing.
>I would also like to mention that if your performance problems are related to initialization time of the grouping engine and loading data from a dataset, there are also some standard optimizations that let you speed up the grouping engine.
>Please use these settings and check if they make a difference:
>void OptimizeGrid(GridGroupingControl gridGroupingControl)
> // Couple settings to perform better:
> gridGroupingControl.Engine.CounterLogic = EngineCounters.FilteredRecords;
> gridGroupingControl.Engine.AllowedOptimizations =
> gridGroupingControl.TableOptions.VerticalPixelScroll = false;
> gridGroupingControl.Engine.TableOptions.ColumnsMaxLengthStrategy = GridColumnsMaxLengthStrategy.FirstNRecords;
> gridGroupingControl.Engine.TableOptions.ColumnsMaxLengthFirstNRecords = 100;
>Based on the specific way you use the grouping grid more optimizations could be suggested, but I would need to more details about the application, the data and which features of the grouping engine you are using.
>If you can provide us with a sample that gives an idea about the specific requirements of your application we will also be glad to debug and look at such a project and see how the grid can be optimized in more detail.
>Also refer the browser samples for more details.