Hello,
I am using the WebDataGrid control from version 14.1.20141.2392 and checking to see if there are any options or suggestions on improving the rendering/loading time of WebDataGrid that has large set of data. For example, I noticed in a production environment, it took approximately three (3) minutes for the grid to render that had 14,444 rows (up to 17 columns). I confirmed that that our query to generate the results did not have any impact and even noticed in IE F12 Developer Tools that the Profiler tab reflects the time spent on Infragistic control.
My questions are:
1) Is there anyway to improve the rendering time?
2) Does this control support paging or lazy loading?
3) Is there another grid control that you offer that can handle this large set of data but also provide the ability to sort and filter columns?
Please let me know if you have any questions.
Thanks,
Ian
Hello Ian,
Thank you for the detailed information you have provided.
1) and 2) - In order to improve the rendering time of the WebDataGrid, I can suggest you take a look at the Paging and the Virtual Scrolling behaviors of the control. By adjusting their settings according to your application, you can increase the rendering performance.
For example:
<ig:WebDataGrid> <Behaviors> <ig:Paging PagerAppearance="Bottom" PageSize="8" Enabled="true" /> <ig:VirtualScrolling ScrollingMode="Virtual" DataFetchDelay="100" RowCacheFactor="20" ThresholdFactor="0.5" Enabled="true" /> </Behaviors> </ig:WebDataGrid>
3) Another grid control I can suggest you use is the igGrid, which is a jQuery-based client-side grid. Since its whole lifecycle is on the client-side and is independent from the server-side, you would observe an increased performance when it comes to comparison.
Please note that lots of changes and optimization logic have been included to our WebDataGrid since the ASP.NET 14.1 product and I can suggest you upgrade to a more recent version of the product.
For more detailed information on the Paging and Virtual Scrolling behaviors of the WebDataGrid, you can take a look at the following online sample and topic.I have attached a sample application that demonstrates the approach from above. (You may have to modify the build version of the registered assembly in order to run it.)
If you have any questions, please let me know.
1616.WebDataGrid_sample.zip
Sincerely,TachoEntry-Level Software Developer
Thank you Tacho! That helped and was what I was looking for. Another question. Is there a way to wrap the page numbers when this option is implemented? For example, I did a PageSize of 150 but due to the large result set, I could see the page numbers going past page 150 but I can't scroll to see the page numbers. The way I noticed was making the browser window wider. I tried put the control within a DIV and set overflow to auto but I got the same results (not seeing the upper range of the pages)
Please ignore. I found a valid option which was using the NumericFirstLast PagerMode and QuickPages for the Paging object.
Thank you for the feedback.
I am glad to know that you were able to achieve the functionality you were looking for.