What is the most efficient procedure for implementing a sortable ajax list on the backend?
- by HenryL
The most common method is to assign a sequential order field for each item in the list and do an update that maintains the sequence with every ajax sort operation. Unfortunately, this requires an update to each item of the list every time someone sorts. This is fine for small lists, but what's the best way to implement sorting for larger lists that are constantly updated?
I am looking for something that minimizes DB IO.