I found that when I use editor to create or update the row in serve side mode and use drawType: 'page', option, it it will refetch all the data each time, I think this is slow and waste, So how can I update only the changed row ?
It does that as the edit may change the ordering/paging/search results - the client needs to ask the server for the new page data based on the result of the edit. I don't think there's anyway to avoid that.
@colin thanks for sharing, I want to know If I only change some field and will keep the ording、paging and search, It is any possible to manual update the row data ?
You could set the drawType parameter to be none, which will force DataTables not to redraw the table (and thus not make that extra Ajax request). However, the significant draw back to that is that the new data cannot be resorted, filtered or anything else exactly as Colin says. Therefore the table state would be effectively invalid.
Replies
Hi @ihuangmx ,
It does that as the edit may change the ordering/paging/search results - the client needs to ask the server for the new page data based on the result of the edit. I don't think there's anyway to avoid that.
Cheers,
Colin
@colin thanks for sharing, I want to know If I only change some field and will keep the ording、paging and search, It is any possible to manual update the row data ?
You could set the drawType parameter to be
none, which will force DataTables not to redraw the table (and thus not make that extra Ajax request). However, the significant draw back to that is that the new data cannot be resorted, filtered or anything else exactly as Colin says. Therefore the table state would be effectively invalid.Allan