How to add only new rows without reload them all?

superfox

Hi! How can i configure datatables to add only the new rows inserted in the database and update rows to reflect database changes?
i should use the fnAdd/DeleteRow function api and manage all by myself or does exists some automated process and/or specific configuration to listen what happens in the db?
i dont' need to append but insert only the new rows in the right position..

i'm sorry if this question has been already asked but i cant find a search option in this forum, maybe i've missed it or is not present at all?
thanks..

superfox

any help.. pleeease!!!

girishmr

One way is to set a flag in your database for all newly added records and redraw only for those records matching your flag ! basically the query will return only those records which are newly added based on this new flag. Atleast this may give you a direction if not the best solution.

superfox

manually it can be solved creating a buffer, a particular table, with the last CRUD operations executed .. after the buffer is read it can be flushed and so on..

i was wondering if there was some automated process or specific api function to do this work..