Dynamic loading in datastore

Suite and Optimus Suite 5
#1

Hi,
Is there is any way to load the data in datastore dynamically like the one in grid & connector?. For example, loading big dataset with 20000 records…

#2

It will not work for the standalone datastore, but if you will set it as a source for grid with smart rendering or paging - datasource will load data from server side by chunks, same as the grid.

#3

do I have to use the function

mygrid.sync(data);

with data as defined as datastore and with URL point to a php where it loads a xml with posStart & count?.
Can you please point out what are the options to use to achieve this?.

#4

Let me explain the requirements of my project.
I have a initially used datastore to load the data from DB, but since it got around 600 rows which took around 10 secs to render because, the server side involve to interpret 5-6 tables to get a single row. I have attached dataprocessor to the datastore. Any updates in datastore triggers the update/delete operation. But with this setup, I can load the data in datastore and bind to Grid & Form and I can save and see the update on the grid without any refresh.

I have decided to use the SmartRender option in grid to load only 30 rows at a time, so I have loaded the data in grid, and I bind Form. When I attach dataprocessor to grid, there were no rows sent when I modify the data in form. When I attach dataprocessor to form, the data sent to server, but no refresh happened in grid. How to do it?.

#5

Check the attached sample
dyn_srnd.ZIP (124 KB)

#6

Thanks, before getting the answer from you, I have tried myself like the solution you have attached and it works fine. But the datastore.js always load the datatype as json, whereas my data is xml which causes javascript error. I have edited the datastore.js and now it works fine.

from

  typeof call == "string" ? (this.data.driver = dhx.DataDriver[call], call = JSCompiler_OptimizeArgumentsArray_p0) : this.data.driver = dhx.DataDriver.json;

to

  typeof call == "string" ? (this.data.driver = dhx.DataDriver[call], call = JSCompiler_OptimizeArgumentsArray_p0) : this.data.driver = dhx.DataDriver.xml;