I have a dataset with 10 rows and 144 columns.
The query fetching from DB is so fast, but, i don't see the output on the grid for 5 to 10 seconds.
Even thought i have 144 columns, only max 20 of them is only displayed on the grid, all other columns are hidden.
I actually need those hidden column internally for doing some processing.
I use UltraGrid 12.2 with VS 2012.
Is there any know issues with the version of ultragrid to bind that many columns?
What are the ways to reduce the binding time?
Thank you,
Hi Toji,
I tried this out and it works just fine for me. Binding the grid is nearly instantaneous. I have attached my sample here so you can try it and see if you get the same results.
So my guess is that there is something else in your application that is causing the slowdown. Maybe you are handling an event on the grid and your code is not as efficient as it could be. Or maybe something is not set up correctly and there are exceptions that are getting raised and caught, but are still slowing down the execution of your app
I recommend taking a look at the WinGrid Performance Guide. If that doesn't help, try posting a small sample project demonstrating the problem and I will be happy to take a look at it for you.