Last post Jun 16, 2011 04:52 AM by toas1
Jun 14, 2011 11:58 AM|Steve Goettler|LINK
Hi We are developing an application where we are supposed to show 2 years of mondays (starting from today) in a Grid and we need the grid to be a three level hierarchical grid.
I already developed this in asp.net 3.5 using infragistics asp.net grid. But with the amount of data and caluculations I have the page is taking a lot of time to load now and the browser hangs up.
Every cell is editable and each of the date has particular importance we have to colour that depending upon date.
So Can you guys suggest me how to lay the database design for this and how better we can bind the grid to make things faster?
Jun 14, 2011 01:09 PM|Jeev|LINK
Can you ofload the calculations and cache the results so that the page does not have to do it every time some one hits it? This would be one way to reduce the load time. Alsos if paging is an option ; I would page the grid so that you are loading a sub
set of the data at a time
Jun 15, 2011 11:55 AM|ajitsunny|LINK
If possible please attach the image/screenshot of your grid, so that we can suggest you a better solution.
My questions are
1. whether you are doing all calculation & manipulation at client side or server side?
2. The performance issue is with all browser or only with IE? If till now you have not checked it in all browser plz check it.
Jun 16, 2011 04:52 AM|toas1|LINK
It sound like you have two problems, one is that there are to much data (to many rows) in your grid and the second one is that your calculations take to long time and you need different solutions for them:
For your first issue I see no other option then to use some kind of paging or partial loading. You could use buffered scrolling if your grid support it (or if you could implement it your self) to give you the feeling of having all data loaded from the begining.
How many rows are we talking about?
For the second one, do you need to recalculate the data every time you load the grid? If not use some kind of caching, either you could you have job thats calculate it every 5 minute or so and then stores the calculated data either in a table in the database
or you could use the asp.net cache to store the data for a while? you could also have a cache dependency for your asp.net cache thats recalculate your stored data when a table inyour database is updated.