Clear is slow

[trintyParticipant]

Hello,

What is the difference between calling jqxGrid(‘clear’); and just looping through all rows and deleting them? I’m asking because calling clear is a lot slower

[Peter StoevKeymaster]

Hi trinty,

It depends on the number of rows. Clear removes and re-renders the Grid with empty view.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[trintyParticipant]

So this is what we are doing:

Clear:
“
$(jqxGridQueryId).jqxGrid('clear');
“
Delete:
“

var grid = $(jqxGridQueryId);
var rowCount = grid.jqxGrid('getdatainformation').rowscount;
var rowIds = [];
for (var i = 0; i < rowCount; i++) {
    rowIds[i] = i;
}
grid.jqxGrid('deleterow', rowIds);

“

Somehow Delete is a lot faster

[Peter StoevKeymaster]

Hi trinty,

Which one is faster depends on the numbers of rows. If in your case one is better than another, then use the one you wish.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts