makrio/makrio — pull request #12 by jancborchardt (2012-06-30 02:18:51+00:00)
Title: change decay unit from days to hours for more granularity

(Had some help from @Wraithan who knows more about PostgreSQL)

Using hour level difference is better than days so that posts before and after midnight don’t have that big of a difference in rating.

For increased performance, @Wraithan advised that we should use a stored procedure instead of putting the SQL in the code, at least when it starts to need to scale. (Or also cache the results for some minutes.)
And we also should factor in remixes here soon. This is more complicated though because of the idea of what was the original.