Hi Jason, Thanks a lot for the reply. We are using UltraWebGrid v7.3 compatible with Asp.Net 2.0 for our application. Our primary motive is to display data and hence we are not interested in updating/inserting/deleting data back to the DataSource. Regarding the DataSource - We build a DataTable with required data from the database and bind to the grid. Now comes the issue. After binding the dataSource to the grid, we add 546 columns to the grid and and then add desired data in each of the 546 columns for each of the record present in the grid ( not to the data table). Now once this finishes, the grid takes close to 5 minutes to load!!!!. We are manipulating the grid and not the data table because we have seen similar logic applied to VSFlexGrid in VB platform and work flawlessly. We need to change the text colour of some of the column data for certain rows based on a logic, and hence we cannot avoid looping through the rows of the grid. Now, once we make these changes (like adding more data to the extra columns/changing colour)etc., (which happens very fast), the grid is not loading.. or taking a lot of time.. please guide us to solve this problem..

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

 

 

Thanks for the quick response. We will stay tuned :-). Thanks.

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.