|
tbh would be easier and use less cpu time to just run a script every day|hour|etc to do a select to work out all the rankings, then update each field with its new rank.
no need really to calculate the rank every time it is requested. (unless the site / prog needs it to be real time)
|