kareha_ Posted December 9, 2012 Share Posted December 9, 2012 Hi. I do not know if this is already known, but the leaderboard page is very slow to build. Is it possible to improve this? Or are there already too many psnids? Because the number of gamers quite nice rises in recent times? Incidentally, it is the best leaderboard page that I know Good job ! Link to comment Share on other sites More sharing options...
AlteredFormula Posted December 9, 2012 Share Posted December 9, 2012 Its usually a lot quicker than the 7-8 seconds at the moment. My guess is there is an automated mass update going on at present. Link to comment Share on other sites More sharing options...
kareha_ Posted December 9, 2012 Author Share Posted December 9, 2012 You mean many people updating there card? Link to comment Share on other sites More sharing options...
Sly Ripper Posted December 9, 2012 Share Posted December 9, 2012 It's because the leaderboard is sorted by points desc, total asc. MySQL can't use an index to order when you mix the directions. I'll work on trying to do it quicker using a subquery too. Link to comment Share on other sites More sharing options...
kareha_ Posted December 10, 2012 Author Share Posted December 10, 2012 I understand. Wouldn't a "ORDER BY points desc, platinum desc, gold desc, silver desc, bronze desc" almost do the same? Link to comment Share on other sites More sharing options...
Sly Ripper Posted December 10, 2012 Share Posted December 10, 2012 Made some changes, try it out. Link to comment Share on other sites More sharing options...
kareha_ Posted December 10, 2012 Author Share Posted December 10, 2012 As fast as hell Thank you! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now