Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Reshmi on Jun 24, 2008 01:54
open dhtmlx forum
regarding summing up in tree grid

Hi

we have a treegrid with 4 levels.. at each level summing up is done.For this we used below code

mygrid.setColTypes("tree,txt,txt,ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=sum],ro[=c3+c4+c5+c6+c7+c8+c9+c10+c11+c12+c13+c14]");
this is taking almost 45 secs to load.....


when we tried without summing the grid got loaded instantly
    mygrid.setColTypes("tree,txt,txt,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro,ro");
    

can we do summing up after loading grid . (or is there any other way to increase performance as users need level wise total)
we tried smartRendering and smartXMLParsing but it dint make any difference.


Thanks nd Regards
Reshmi
Answer posted by Support on Jun 24, 2008 04:02
The problem is that performance increasing techniques, such as smartRendering and smartXMLParsing can't be used with math calculations ( to work correctly , math require that all rows in treegrid must be rendered ) - as result it works much slower

>>can we do summing up after loading grid
It possible to implement such usecase, but it will not give big benefits - the grid still need to have all rows rendered , which cause browser freezing on the same time.

As possible workaround - you can calculate all sum values on server side ( as far as I can see all math cells is readonly in your case )