GridGroupingControl Load Performance

[vbaker]

I am using a GridGroupingControl with a master and one child table in the datasource. The grid is on a form, which opens upon user menu action.

The datasource master consists of about 2500 rows, and each row in the master has one child row. The master has about 15 columns and the child about 5. I use the form''s OnLoad event to fill the dataset from the database and bind the grid to that dataset. The grid TableModel is readonly, because the grid is never edited by the user, but a row can be double-clicked to permit choosing a desired record to view in another form.

When the user menu action occurs, it takes about 30 seconds for the form and its grid to appear. Users consider this delay excessive, and I agree. Using console debug output, I''ve verified that the master and child data sets are "filled" by their data adapters very quickly. So the delay appears to be in the rendering of the grid, some time after the form''s OnLoad event starts to run.

Any suggestions for improvement?

--Van Baker

[Administrator]

Hi Van,

I think what you need is very much related to what is discussed in http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=26047

I think these optimizations will help a lot in your case.

For now, you can only optimize things by using techniques shown in GroupingPerf, but the EngineOptimizations will give you much better performance.

Let me know if you are interested in testing engine optimizations discussed in the thread. Best is to open a dtrac incident and refer to this forum thread.

Stefan

>I am using a GridGroupingControl with a master and one child table in the datasource. The grid is on a form, which opens upon user menu action.
>
>The datasource master consists of about 2500 rows, and each row in the master has one child row. The master has about 15 columns and the child about 5. I use the form''s OnLoad event to fill the dataset from the database and bind the grid to that dataset. The grid TableModel is readonly, because the grid is never edited by the user, but a row can be double-clicked to permit choosing a desired record to view in another form.
>
>When the user menu action occurs, it takes about 30 seconds for the form and its grid to appear. Users consider this delay excessive, and I agree. Using console debug output, I''ve verified that the master and child data sets are "filled" by their data adapters very quickly. So the delay appears to be in the rendering of the grid, some time after the form''s OnLoad event starts to run.
>
>Any suggestions for improvement?
>
>--Van Baker