Hi,
I have a hierarchical dataset(with relations) that is populating a infragistics grid. The grid loads with some child records for each row. When i first time click on the one of the + sign, it just hangs in there for a long time. After that subsequent operations perform little better. The total records are couple thousand.
There is no even that is getting fired when it is hanging. Any ideas/pointers on what might be wrong?
Thanks in advance for your help.
Well, if the CalcManager is causing a performance issue, then something is clearly wrong. You might want to see if you can narrow down which formula is causing a problem. I would try turning off one formula at a time and see when the problem goes away.
Are you getting a lot of formula errors?
The datasource of my grid is dataset (2 tables with relations).
I did some research with my code and adding the following line of code resolves all the issues.
myultragrid.CalcManager = null;
Now the problem is, I need the ultacalcmanager with this grid because users of the application can add custom formula columns into this grid.
Any ideas/pointers in what could be the best way to resolve this issue?
Thanks.
When you click the expansion indicator, the grid has to go out and retrvieve the child rows for that particular parent. This can be an expensive process depending on the data source. But I can't see why it would be slow with only a couple of thousand rows.
What are you using for the DataSource of your grid?
Is your data source recursive? If so, try setting MaxBandDepth to something like 5 and see if that helps.
Another thing you can try, as a test, is setting SynchWithCurrencyManager to false. If that helps, it means that the performance issue is being caused by changing the current position of the BindingManager. If that's the case, you might try using a BindingSource to wrap your data source, if you are not already doing that.