Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If the table is very large, it may take time. As I suggested in Update rank on a large table, you may want to limit the ranking to the first 10,000 when ranking frequently, and then do the fuill ranking maybe once a week or once a month.

I gotta run to a company meeting, Back back in an hour... (I am still thinking..., error is probably ORDER BY two JOINed tables in UPDATE. My past answer did ORDER BY on a single table)
–
RolandoMySQLDBANov 20 '12 at 19:04

I think ORDER BY...DESC cannot be applied on a JOIN. I changed my answer to perform ORDER BY...DESC on score table before doing the JOIN.
–
RolandoMySQLDBANov 20 '12 at 20:04