title: Is storing rank values in relational table a good idea?
body: <p>I have read some question related to this but they do not picture exactly my cenario. I have a table that has a column representing the number of views of the item; lets say 1000, 20. I want to give it a rank based on the number of views. So when I sort the results I want sort them by rank instead of being too much mathematical and position an item above another only because it has one view more than the other. </p>
  
  <pre><code>item
  id view view_rank (is the view_rank here a bad practice? Why?)
  1   1000   3
  </code></pre>
  
  <p>I want to do this because if don't do so I will have to use write a raw sql instead of using my ORM.
  Also consider retrieving 100.000. Using a rank function for 100.000 can be significant.</p>