Dataview and Big Data Set? Smartloading?

Suite and Optimus Suite 5
#1

Hi,
I would like to use the DataView and I wonder if a smart loading mode is available for big data sets?

I thank you for your answer.

Best Regards,
Miguel Ange Martin

#2

Yes, Smart loading (dynamic loading) is supported in Dataview.
Below are some samples on its usage:

http://dhtmlx.com/docs/products/dhtmlxDataView/samples/01_initialization/01_dynamic_loading.html
http://dhtmlx.com/docs/products/dhtmlxDataView/samples/01_initialization/02_dynamic_paging.html

It seems to work very well (my dataset had 30,000 entries)
However i had some problems getting it to work (see my post below from couple days ago. Awaiting response from DHTMLX team)
http://forum.dhtmlx.com/viewtopic.php?f=8&t=21496

If you are using rener_sql function to load the data in dataview, it seems to work as long as you are querying data from one table

$data = new DataViewConnector($conn);
$data->dynamic_loading(50);
$data->render_sql("Select * from $t1","id","value");

If you are running complex queries, involving multiple tables, it did NOT work for me and all data was loaded. May be DHTMLX Team can shed light on this too hopefully with an example.

#3

Thank you for the answer.