|
Title: Performance problem large dataset datagrid detailview Post by: Ellipsis on April 03, 2013, 03:20:42 AM When loading approx 1000 rows in a detailview datagrid (10 columns) the scripts are too slow. The browser complaints.
When disabling autoRowHeight we have a very small performance improvement, the add events (onExpandRow) seems to slow things down. The functions calledc send a jQuery each object to function _474 (min version). Please consider improving performance by minimizing the use of jQuery each. see this performance test:http://jsperf.com/jquery-each-vs-for-loop/135 (http://jsperf.com/jquery-each-vs-for-loop/135) Pagination is no option, all the rows are needed in a single page. Do you have any suggestions for now? Title: Re: Performance problem large dataset datagrid detailview Post by: wilfo on April 03, 2013, 05:59:48 PM Well , i think you are obligated to devided the information in two parts at least.If they 100 , tekae only 50 by 50.
Other ideas which comes to my mind , it's that you have diferentes grids ,for example grid "a" and "b" then when you select one row at that event you load the data in the grid "b" .This is valid if subgrid processing it's too low. Title: Re: Performance problem large dataset datagrid detailview Post by: Ellipsis on April 04, 2013, 12:43:02 AM That is no option, we need to render at least 1000 rows without real performance issues.
Title: Re: Performance problem large dataset datagrid detailview Post by: stworthy on April 04, 2013, 03:12:11 AM The virtual scroll view can be used to display large data set. Please refer to http://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=Virtual%20Scroll%20View%28Detail%20Rows%29.
Also, delay creating detail content can improve performance. Title: Re: Performance problem large dataset datagrid detailview Post by: Ellipsis on April 04, 2013, 06:12:53 AM Thank you for the answer.
But it still does not solve the problem of showing large sets of data, for example >200 rows. The delay helped a bit, but stil the render is very slow. Title: Re: Performance problem large dataset datagrid detailview Post by: stworthy on April 04, 2013, 06:21:53 AM Please refer to this example http://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=Large%20Data. It loads large data quickly.
Title: Re: Performance problem large dataset datagrid detailview Post by: Ellipsis on April 04, 2013, 07:19:11 AM Yes that is correct, we do not have problems with the regulare datagrids, only the detailview extensions causes performance problems.
Title: Re: Performance problem large dataset datagrid detailview Post by: stworthy on April 05, 2013, 10:05:58 AM Please download the updated detailview from http://www.jeasyui.com/extension/downloads/jquery-easyui-datagridview.zip. And define a expander column like this:
Code: <table class="easyui-datagrid" ...> |