performance issue in setcellvalue method

[beyond8848Participant]

Hello Expert,

we am running into performance issue regarding setcellvalue method
A jqxgrid table with 5000 records in our UI, it consists of around 50 columns, one of them is checkbox type to indicate whether user did update data record or not ,
Suppose when user select over 600 records to update at same time ,and we invoke the below way to update checkbox value as true. the time cost is too high so that UI is responseless.

       for (var i = 0; i < rowNums.length; i++) {  // here rowNums is over 600 
               
                    $("#" + gridId).jqxGrid('setcellvalue', rowNum[i], 'Isupdated', true);
                              
            }

do you guys have workaround to avoid this issue?

Thanks in advance.

Best Regards

[adminKeymaster]

Hi beyond8848,

setcellvalue refreshes the Grid which means that in your loop you refresh it 600 times. This will of course result in performance issue. To avoid it, use beginupdate and endupdate Grid methods before and after your loop.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts