locked
Any Ideas to Implement this?? Urgent!!! RRS feed

  • Question

  • User1719168646 posted

    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?

     

     

     

    Tuesday, June 14, 2011 11:58 AM

Answers

  • User-2004844803 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 16, 2011 4:52 AM

All replies

  • User-125547262 posted

    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

    Tuesday, June 14, 2011 1:09 PM
  • User1399096257 posted

    Hi Steve,

    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.

    Ajit

    Wednesday, June 15, 2011 11:55 AM
  • User-2004844803 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 16, 2011 4:52 AM