I am trying to bind 30,000 rows with 53 columns to UltraWinGrid, and in the Initialize layout I am grouping the grid by column x and I also have custom summaries for 45 columns.
It takes around 12 seconds to bind the datasource. Can anyone let me know how to increase the performance of the grid. (There are no updates in the datasource).
Thanks,Rajesh M.
Hi Rajesh,
It's really hard to guess what's happening with so little information. How are you measuring the time? How do you know it's the binding that taking so long?
When are applying the grouping? Are you loading a layout file? Or are you grouping in code?
Hi Mike,
I am using xml string to apply the grouping in the initialize layout event. I use below code to measure the time.
Dim sw as New StopWatch()
sw.Start()
grid.DataSource = xyz
sw.Stop()
Thanks,Rajesh
Are you grouping by more than one column?
What version of the controls are you using?
We've made some performance optimizations in this area of the code recently, so the first thing I recommend is that you get the latest service release, if you don't already have it.
How to get the latest service release - Infragistics Community
If the service release doesn't help, then we would probably need to see a small sample project demonstrating the issue so we can check it out and see if there is anything we can do to optimize it further.