This is a migrated thread and some comments may be shown as answers.

Kendo Grid with large number of columns

6 Answers 832 Views

Grid

This is a migrated thread and some comments may be shown as answers.

6 Answers, 1 is accepted

answered on 29 Oct 2012, 12:30 PM

Hi Suril,

the scenario with a large number of columns is currently poorly supported, due to a O(n^2)-Implementation of the ColumnChooser. (and a 250-column grid without a column chooser doesn't seems a very sensible scenario). Except for loading time, also the selecting / deselecting of columns seems to be disproportionally expensive with the number of columns.

Things are getting a lot better with jQuery 1.8.2 (Kendo UI Q3), but still it lags a lot, especially in Internet Explorer. With a grid of ~50 columns on a modern PC it is roughly bearable. As the costs are n^2, I guess 250 columns will make most browsers crash using the current implementation.

The template for the column chooser is evaluated for every column, so is also the for-loop inside:

'#if(showColumns){#'+

'<li class="k-item k-columns-item"><span class="k-link"><span class="k-sprite k-i-columns"></span>${messages.columns}</span><ul>'

+

'#for (var col in columns) {#'+

'<li><label><input type="checkbox" data-#=ns#field="#=columns[col].field#" data-#=ns#index="#=columns[col].index#"/>#=columns[col].title#</label></li>'

+

'#}#'+

'</ul></li>'+

'#if(filterable){#'+

'<li class="k-separator"></li>'+

'#}#'+

Does anybody have a workaround for this performance issue (except for disabling the column chooser or implementing it separately ..)? Actually it would be sufficient to generate the list only once, as it is identical for all columns.

Additionally I believe it would be a very welcome feature to offer a customizable ColumnChooser, that can be placed e.g. at the toolbar. To some people the columnChooser doesn't seem very intuitive inside a column menu, as it doesn't offer any functionality, that is specific to the column. This way, the performance-problem would be solved too.