grid + datastore

Suite and Optimus Suite 5
#1

Hello,

I have a grid which is synced with a datastore. My grid has about 500 rows and 130 columns.

when I use the update method of DataStore for loop it becomes too slow and even shows the javascript dialog which let user to choose whether continue or not.

Here is my code.

  mygrid = new dhtmlXGridObject('gridbox1');
  mygrid.setImagePath(dhtmlx_gird_imgs);
  mygrid.setSkin("dhx_skyblue");
  mygrid.attachEvent("onRowSelect",onMygridRowSelect);
  mygrid.attachEvent("onCheck",onMygridCheck);
  mygrid.attachEvent("onRowCreated",onMygridRowCreated);
  mygrid.attachEvent("onBeforeSorting",sortGridOnServer);
  mygrid.attachEvent("onKeyPress", onMygridKeyPress);
  mygrid.enableSmartRendering(true, 10);
    function dhtmlGridHeaderChkOnclick(){
                var rowsCount = myGridDataStore.dataCount();
		for (var rInd = 0;rInd < rowsCount;rInd++) {
			var itemId = myGridDataStore.idByIndex(rInd);
			var item = myGridDataStore.item(itemId);
			if (item.xxx != '9') {
		               item.yyy = value;
		               myGridDataStore.update(itemId, item);
			}

		}
   }

Is there any faster method ? Please help me.

Thanks in advance.

Jack

#2

unfortunately it’s not available to increase the performance in this case.