Problem in loading big datasets


#1

I have 100000 data rows in grid. I want to load that big data in grid smoothly. I used
both the methods of my grid:-
mygrid.enableSmartRendering(true,50);
mygrid.enablePreRendering(10000);
But its not working well.


#2

In case of such big datasets you need to implement the dynamic loading of data.
Here you can find a tutorial:
https://docs.dhtmlx.com/grid__dynamic_loading.html
and working example:
https://dhtmlx.com/docs/products/dhtmlxGrid/samples/14_loading_big_datasets/03_grid_dyn.html (200k records here)


#3

Is that requires a Dhtmlx Professional edition or can be worked on Standard one?
It is not working well for data of 100000 rows in grid.


#4

dynamic loading of data can be used with the STD versiosn of the dhtmlxGrid.


#5

When we are using that method enableSmartRendering(true,50) for Dhtmlx v5.1(Standard) we are getting only 2 rows in the grid, but when we use enablePreRendering(10000) along with enableSmartRendering(true,50) we are not getting actual rows for large dataset (for around 1L rows ).
Does it requires Professional License edition to get the full features of the dhtmlx library, because its working fine with dhtmlx 1.6Version( professional edition) only by using enableSmartRendering(true,50) for large dataset.


#6

I have linked you sample:
https://dhtmlx.com/docs/products/dhtmlxGrid/samples/14_loading_big_datasets/03_grid_dyn.html
It works well with STD version of the dhtmlxGrid. You can find the similar sample in your dhtmlxGrid package.
The sample works smooth and loads 200k records.
Please, note that adding

enablePreRendering(10000)

won’t increase your performance, but only force the grid to render additional 10000 rows right now, and make the grid to become “not responsive” for this time.
Please, make sure that you really need to pre-render some additional rows to your grid. If it is really needed please, try to decrease that size to the height of your gridview.
If the problem still occurs for you please, provide a complete demo or a demo link, where the problem can be reproduced locally.


#7

The link you had provided is not working well for the Internet Explorer 11, but working fine on Google Chrome. Is there is some browser compatibility issue for the same?