Viewing 0 reply threads
  • Author
    Posts
    • #1563215
      Michael Pietroforte
      Keymaster
      Member Points: 31,739
      Author of the year 2018
      Rank: 4

      I’ve built now my own cache for the member leaderboards because the cache of the corresponding plugin was unreliable. The year and the month leaderboard pages are updated every full hour. The small leaderboards with the top 3 members on the homepage and on the side-wide activity page is only updated once per day because otherwise the homepage would be too slow.

      It currently takes more than 10 seconds to build the leaderboard because the SQL query is quite expensive. The bigger the corresponding database tables become the worse it gets. So this is only a temporary solution.

      Whenever it takes 10 seconds to load a member leaderboard page, you know that the leaderboard has just been updated.

      The author leaderboards are unaffected. This all my own code anyway, so no performance issues here.

Viewing 0 reply threads
  • You must be logged in to reply to this topic.
© 4sysops 2006 - 2021

CONTACT US

Please ask IT administration questions in the forums. Any other messages are welcome.

Sending

Log in with your credentials

or    

Forgot your details?

Create Account