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

Filed under:
|
|

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

Related posts about schema

Related posts about AJAX