Hello Anand,
Thanks for sharing your solution. If you haven't done so already, I would recommend you take a look at our new WebDataGrid released with 2008 Volume 3. We have done a lot of performance improvements within this new grid control.
-Taz
I think you are also facing same problem as I had.
this is a known performance Issue with IG Grid having more then 1000 rows with around 5-8 columns,
you can refer to this case CAS-09408-5YNFAV
there is no resolution for this problem.
either reduce your size to 200 rows or face performance issue.
one nice solution can be you can use paging if possible in your case.
Hello Bill,
As Jason mentioned, the dimensions of the data is not very common for a web-based solution and I would not recommend that. I tried binding a simple data table with 1000 rows and 550 columns, and it took too long to render.
Is there any way you could give your users a load on demand type senario? You can bind the datatable that you fetch from the database as is to the WebGrid and either on a row click or a row expansion you display more information of that row.
If this could work for you, then I think it will tremendously help improve your overall page perfromance, and if you look it from a usage perspective, not all users that visit the page would look at all the records/items that you want to display.
-Taz.
Ahhh, that makes more sense now. 546 columns in a grid will not perform well in a web based solution. For VB FlexGrid, all of the work is being done in memory on the client, and the painting is done w/ GDI. The architecture is very different.
I will forward this post to Murtaza, the PM for ASP.NET, and see if there is some ideas he has on this performance.
Stay tuned,
Thanks
Jason