What is the most efficient procedure for implementing a sortable ajax list on the backend?
Posted
by HenryL
on Stack Overflow
See other posts from Stack Overflow
or by HenryL
Published on 2010-04-21T01:23:30Z
Indexed on
2010/04/21
1:33 UTC
Read the original article
Hit count: 263
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.
© Stack Overflow or respective owner