yes, you are right. My bad. Of course, in the worst case (if the last slot is repositioned to the first slot) all the rows will have to be recalculated.

What you are suggesting is what I had resigned myself to doing with the database. My guess is, DBI should be fast enough to not worry about it.

Its just that it seems like an inelegant method. Hence, my question in the first place.