DHTMLXgrid is not loaded when there are million records

Hi,

We are using DHTML XGrid (Pro 2.5) in our application and we are loading the grid from an XML. We have enabled smart rendering to load 200 records per scroll and it works fine when we data less than a million. If the total number of rows is more than a million then the grid is not loaded properly. We are not getting any errors in the screen and only the column header is displayed in the grid.

My doubt is we are loading only 200 records during the initial time. Why grid is not able to display those 200 records irrespective of the total count?.

Could you please help me to sort out this problem?

MyGrid code setup:

mygrid = new dhtmlXGridObject(“gridbox”);
mygrid.setImagePath(URL_DHTMLX+“codebase/imgs/”);
mygrid.setEditable(false);
mygrid.enableCellIds(true);
mygrid.enableMultiline(true);
mygrid.enableEditEvents(true, true, true);
mygrid.enableStableSorting(true);
mygrid.init();
mygrid.disableContextMenu();
mygrid.setSkin(“dhx_skyblue”);
mygrid.enablePreRendering(50);
mygrid.enableMultiselect(true);
mygrid.enableSmartRendering(true, 200);
mygrid.enableDistributedParsing(true, 200, 200);

Regards,
Karthik

If you really have million records you should reflect about your data model.

Why? That’s not a large database.

Please try to enable dynnamic smart rendering mode or paging mode.
You can find the tutorial here:
http://docs.dhtmlx.com/doku.php?id=dhtmlxgrid:common_performance_techniques

Perhaps not a large database but a bad view.