Take a look at this Rails gem, https://github.com/mixonic/ranked-model/ https://github.com/mixonic/ranked-model/ It's a bit more efficient than traditional ord

Take a look at this Rails gem, https://github.com/mixonic/ranked-model/ https://github.com/mixonic/ranked-model/ It's a bit more efficient than traditional ordering... From the readme: ranked-model is also optimized to write to the database as little as possible: ranks are stored as a number between -8388607 and 8388607 (the MEDIUMINT range in MySQL)