I Found dhtmlxgrid and dhtmltreegrid has a fatal Defect Relative to other products,for example jqgrid,extjs grid and treegrid.
The Problem is dhtmlxgrid and dhtmltreegrid is very very slow when update many row cells value,for example:
get 5000 row of treegrid cell, almost 6.5 seconds,
the method is
for(var i=0;i<5000;i++){
grid.cells(‘rd_’+i,0).setValue(‘1’);
}
[b] the meaning is when i change parent node's checkbox value,but it has more than 5000 row data, I will need wait 7 seconds for check all subRows.[/b]
I’M ERROR IN IE9 It need 6seconds,But in Ie7 or ie8 or ie6 it need more than 20seconds
Ther operSystem: Windows 7 64bit
Memory:4g
cpu:Intel i7
The Browser is :Internet explorer 7,8,9,10
the demo is exist in your web site
the method is cells2(id,colIndex).setValue(1),It is used to check all 5000 rows data
there is no other case exist in my demo,I have test in three different computer,the elapsed Time is always more than 6.5 seconds
Sample:
function changeText(){
var dateStr=(new Date()).format("yyyy-MM-dd hh:mm:ss.SSS");
console.log(dateStr);
//alert(mygrid.doesRowExist('r0_150'));
//alert(mygrid.rowsBuffer().length);
mygrid.startFastOperations(); // start "FAST" mode
mygrid.cells('r0_100',0).setValue("*")
for(var t=0;t<5010;t++){
mygrid.cells('r0_'+t,0).setValue('1');
mygrid.cells('r1_'+t,0).setValue('1');
}
var i=-1;
//mygrid.forEachRowA(function(id){
//i++
//console.log(id);
//mygrid.render_row(i)
//mygrid.cells(id,0).setValue("OK")
//});
//console.info(mygrid.getAllSubItems('r1'));
mygrid.stopFastOperations(); // stop "FAST" mode (all events will be skipped between start and stop)
dateStr=(new Date()).format("yyyy-MM-dd hh:mm:ss.SSS");
console.log(dateStr);
}
Unfortunately it’s not available to improve the performance in this situation.
Smart rendering improves the performance for displaying the big number of the rows, but when you need to edit big mount of rows, you need to render all of them. this requires some period. Most of the browsers do this logic fast enough, but old versions of IE (6-8) cannot handle with such mount of data
Get a guaranteed answer from DHTMLX technical support team
under the most suitable support plan