title: How to update list order without reorder list?
body: <p>I have following items in sql-server table. (size > 100K)</p>
  
  <pre><code>Name   Order
  x      1
  ...    n
  y      25
  ...    n
  z      300
  ...    n
  </code></pre>
  
  <p>When change order of item, (z=25) I need reorder all items (x=1,z=25,y=26) My solution is using decimal order column and calculate new order with this formula: "(previous order + next order) / 2" (x=1,z=24.5,y=25) for changed order item. This solution ok, but decimal precision increment every change order. (if changed before)</p>
  
  <p>Is there anything method?</p>