I keep track of the order in a table with field called 'the_order' and it has integers that increment as you add content. However, when I need to reorder a record using a custom CMS I end up moving 'the_order' number to whatever position and UPDATE all items below that up one.
Is there a better solution than this? If you end up having 1,000's of records you can tie up the table. I wondered if anyone had a quicker method.