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.
Column count :
parent 7 columns ( including 4 hidden )
type 1 8 columns ( including 3 hidden)
type 2 6 column ( incl 4 hidden )
type 3 7 columns ( including 3 hidden )
Initialbinddepth set to 1 so everything get rendered upfront, so far this is only way page became operational... ,
Are there any other ways to reduce view state size.. or anything else can be done to speed it up..
Attached is source view of the page, may be something is there that I did not noticed...., do this controls can operate without writing into viewstate ? Anyway, do you have any approach to reduce size of the rendered page ?
Hello mcseidel,
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?
Sincerely, Mike P. Developer Support Engineer II Infragistics, Inc. www.infragistics.com
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
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.
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.