GroupBy Issue

When we have to group our data, we have to call groupBy twice. If we do it once then data doesn’t load properly and is not correctly painted on the grid.

Is there a reason behind that? Following is the way we call our grouping:

function groupGrid0(column)
{
myGridSmartRenderingFlag = false;
myGrid.groupBy(column);
myGrid.groupBy(column);
}

Please, make sure that you are calling the groupBy() method after the data is completely loaded to the grid.

I have found the issue which made us call groupBy two times. When we groupBy to avoid freezing of browser we use distributed parsing. Due to this parsing method when we call groupBy once the data doesn’t get correctly loaded in the grid.

Is there a known issue of groupBy with distributed parsing?

this is the expected behavior.
groupBy() method is incompatible with the dhtmlxGrid performance increasing techniques as it requires the whole data to be rendered completely for the correct grouping

Thanks for your reply. Is there a way to make grouping faster if we have close to 100,000 rows?

Unfortunately it is not available to increase the performance of the groupBy logic.

Sure… Thanks…