Smart rendering is used.
Since the data is not the raw data table, every time a new temporary table is created on server side.
The temporary table is big, and if the client scrolls down, it will access the server side and fetch the tiny part of the whole data again and again, and the temporary table will be created again and again. That’s really time consuming.
Is there any idea to avoid this?
Thanks in advance.
You may try to use the updateFromXML method (you will have to disable the smart rendering):
docs.dhtmlx.com/api__link__dhtm … omxml.html
or you should decrease the number of rows loaded by a single request.
I will try it, thanks Sematik.
updateFromXML works, but this way , how to make the server-side sorting and filtering work again, without passing all the parameters indicating filtering and sorting into the stored procedure?