Intensive use of Ajax requests to delete rows

Intensive use of Ajax requests to delete rows

Philip2Philip2 Posts: 1Questions: 0Answers: 0
edited August 2011 in General
Hi,

I'm building a website that uses a DataTables and that table is populated by a server-side script to display list of items; each user in my website will have his own list of items and each entry in the table will have 4 actions: ignore, hide, and 2 editable textboxes.
The users will be using mainly the ignore and the hide actions, and each one is an ajax request to update the corresponding field in the database, and delete the entry's row from the active table.

So, as the main activity of the user on my website is around these 2 actions: ignore and hide and they will be used intensively, what is the best approach to implement the table, taking into consideration that I want the row to be deleted instantly.

My current implementation is performing an ajax request and waits until the request returns and then redraw the table (to delete the row that has been flagged as hidden or ignored), and that takes some time (about 2 seconds) on a remote fresh database.
This discussion has been closed.