dhtmlx grid data loading for 10k records very slow

Suite and Optimus Suite 5
#1

Hi

Below is code snippet which loads around 10K records from oracle db and takes around ~65 secs (which is not acceptable by end users) to load and populate the data on browser. I am using standard edition of dhtmlx components and used Java connector class to get data.

var gridInfo={
divId:‘downloadDataDetails’,
columnString:“Clinical Study,Study Form,Start Date,End Date,File Type, Exported By,Exported On, Status”,
columnWidth:“10,30,10,10,5,15,15,5”,
columnAlign:“left,left,left,left,left,left,left,left”,
pagingArea:“exportData_PagingArea_div”,
infoArea:“exportData_InfoArea_div”,
//sortInfo:“connector,connector,connector,connector,connector,connector,connector,connector”
sortInfo:“str,str,connector,connector,str,str,connector,str”

}
ExportDataGrid =createGridObj(gridInfo);

ExportDataGrid.loadXML(“LoadgridQString.do?connector=true”);
}

function createGridObj(gridInfo){
var gridObj = new dhtmlXGridObject(gridInfo[‘divId’]);
// gridObj.setImagePath(“dhtml_comp/imgs/”);
gridObj.setImagePath(“dhtml_comp/imgs/grid/”);
gridObj.setHeader(gridInfo[‘columnString’]);
gridObj.setInitWidthsP(gridInfo[‘columnWidth’]);
gridObj.setColAlign(gridInfo[‘columnAlign’]);
gridObj.attachHeader("#select_filter,#text_filter,#select_filter,#select_filter,#select_filter");
gridObj.setEditable(false);
gridObj.setSkin(“dhx_skyblue”);
gridObj.init();
gridObj.enableSmartRendering(true);
gridObj.enablePaging(true, 15, 3, gridInfo[‘pagingArea’], true, gridInfo[‘infoArea’]);
gridObj.setPagingSkin(“bricks”);
gridObj.setColSorting(gridInfo[‘sortInfo’]);
return gridObj;
}

Questions that I have:
1: Can this performance related issue (data loading for 10 K takes a min) be resolved using smart rendering with dynamic loading ? smart rendering with dynamic loading is supported in Standard edition as well, which can be used making gridObj.enableSmartRendering(true). Or have I missed any setting or interpreting smart rendering with dynamic loading incorrectly?

2: And pagination for large data sets is supported in Pro Edition only. I used pagination as given above in code snippet. Does this data loading performance issue can be resolved using pagination with Pro Edition?

Please do reply.
Thanks in advance,
~Shital.

#2

one more point on which need clarification:

docs.dhtmlx.com/doku.php?id=dhtm … ep_by_step
As mentioned in above link, the xml that are passed to grid differs in two properties 1: total_count 2: pos for dynamic loading.

As I have used java connector which automatically generates XML for grid [using connector.render_sql(query) ], Do I need to generate XML programatically so that XML gets generated with above two properties (total_count and pos) set for each row?

#3

First of all must notice that paging mode is incompatible withh smart rendering mode.

You should try to use dynamic smart rendering mode which is supported by standart version of dhtmlxGrid.
It should handle with 10k records.

Else you should try try to use paging mode or a distributed parsing which are includede onli in pro version of dhtmlxGrid.