I would think that you would want to re-rank all your records every
time you displayed the results. Personally, unless I was planning on
doing a join on the rank field (which seems pointless), I would keep
SQL out of the picture as much as possible to maintain maximum
dynamicness.