Free How to Optimize Rank Data in MySQL Tutorial

This scenario occurs often in applications that need to rank and paginate data by some criterion such as popularity, score, or recency. Forums are a good example, as are hot lists on social bookmarking sites.Because the example gaming site has millions of users, the leaderboards use pagination. This means they require a combination of ranking and limits with offets. This is a common requirement, and it’s hard to optimize. The obvious queries will probably not perform well under heavy  
continue >>