I have a page with pretty extensive Hierarchical grid. It takes about 30 - 40 seconds to load on the browser end.
One way to improve loading time is to create paging.. what are other methods to improve performance/shorten loading time ?
Thanks.
Hello mcseidel,
Thank you for contacting Infragistics.
Concerning performance of the WebHierarchicalDataGrid I recommend you see the following behaviors:
Paging: http://help.infragistics.com/Help/NetAdvantage/ASPNET/2012.2/CLR4.0/html/WebHierarchicalDataGrid_Enabling_Paging.html
Load On Demand: http://help.infragistics.com/Help/NetAdvantage/ASPNET/2012.2/CLR4.0/html/WebHierarchicalDataGrid_Load_On_Demand.html
Please let me know if you have any further questions concerning this matter.
Sincerely, Mike P. Developer Support Engineer II Infragistics, Inc. www.infragistics.com
I am following up to see if the information provided has resolved this matter.
Please let me know if I may be of further assistance with this matter.
Unfortunately my speed problems with grid far from over and I’m still trying to figure out avenues to address them.
Here is the setting :
Hierarchical grid with three type of child grids binding of the data set with one master table and three child tables with relationship set. Originally it was load on demand setting that actually was abandoned last moment before production release, It was extremely slow of opening child grids and actually because of requirements to
recalculate values on master grid full postbacks were needed and speed of opening child grid were getting worse with every use.. fast forward, now each child grid is separate predefined band and initial depth set to 1 so there is no postback while data get entered ( all grids are batched, it caused additional issues for load on demand case ) and everything working except one child grid needs add record functionality and adding it bring the whole page to complete stagnation... so for that grid 50 records pushed to create space for entering new data and import created if users need more...
The whole size of data set as following :
Master data table : 260 records
Child grid type 1 : 1550 records altogether means spread between 30 grids ( 50 each, but can be more )
Child Grid type 2 ; 80 records altogether
Child grid type 3 : 10 records altogether
Here the timing ( IE 8.0 official co browser ) :
Initial load time for the whole page : 40 secs
Page size ( shown by fiddler ) : 960,551 bytes
if mane grid paged 20 rec/page and Child Grid type 1 paged 10 record per page
Initial Load 16 sec page size 600,000 bytes, still too big and not flying...
paging : main grid 6 secs , type 1 child 9 secs - this is not acceptable,rather have user to wait initially.
Here what I would like to know : If there are ways to somehow reduce size of the page , may be somehow reduce size of ViewState, Yahoo mail paging happening almost instantly...
I’m looking for other approaches if any on the top what was already discussed ( load on demand and paging).
Thanks
Thank you for your update. Part of the reason you are seeing this is IE8 is slow when dealing with JavaScript which can cause slowdown on your page. How many columns do you have on your parent band? How many on the child band?
While trying to avoid premature optimization scenarios I'm trying to find a culprit... I do not believe that it is network, running browser on the server producing almost the same results.... as for other controls - page has some but it's just another grid with really small data set and drop downs and text boxes ( you've seen the page ), what I'll do when chance is create page with just this grid and see how it perform... we can close this thread for now but rather get back to it when page with single grid results will be available .
Thank you for the update. Performance can depend on a few things amount them are the browser, for example IE8 has issues with JavaScript and that can cause slow down. What other elements you have on the page also makes a difference if you have a lot of tables or a few large tables this can also cause some slowdown. Your network also has an impact on this, I would recommend using IE dev tools or something similar to profile you website and see what kind of responses you are getting. For displaying data you have to remember that each cell in a row is a record and a separate element that needs to be rendered so the number or records you have showing is the number of columns you have multiplied by the number of rows. I have created WebHierarchicalDataGrid’s with more records you have displaying and have run it in IE8 and haven’t seen issues with performance. This leads me to believe your issue is related more to your network and the other items/elements you have on your page.
I still did not have a chance to get back to this part of the project... Here I would like to know a bit more about paging :
Say I have 1500 child records about 100 per child grid. Say I page by 10 records every child grid. So the child grid will be bind to 100 records, only 10 displayed at once, when I click next then 10 other records displayed ... is that 10 records choose when grid gets bound... so 90 records not getting rendered to the browser and only 10 do...
If ajax is enabled so only partial update happen and if it is only 10 records why it does take so long ( about 8 sec ) ?
I am following up to see how you are progressing with this matter.
Thank you for the update. I will follow up in a few business days to see how you are progressing with this matter.