Forum Academy Marketplace Showcase Pricing Features

Database Design - Reddit / Hacker News Style Algorithm

Dear Bubblers,

I am trying to create a repeating group populated thing ranked by score:
I would like the score to be determined by

Score= (likes + comments) / (time-in-minutes-since-posting^2)

Do you have any recommendations for the most performant way to achieve this

I understand i would probably have to cache the top few hundred items - then update that list (probably every 15 mins)

  • Any input here at all would be much appreciated!

This topic was automatically closed after 70 days. New replies are no longer allowed.