(October 4, 2015 at 11:37 am)Tiberius Wrote: They still exist but I removed the links because the code that generates them was taking 5+ seconds to run each time, putting a ridiculous strain on the database.
I wrote the code a few years ago when (1) I was not as good at writing queries as I am now, and (2) when there were way fewer posts / users. Unfortunately the code did not scale well with the site growth.
I think I'll probably replace it with a function that runs automatically once a day and caches the results.
Here's an idea:
could the Smilies be rearranged once a week in order of the average of the most to least used ??
That would put the popular ones on top, particularly my favorite:
The granting of a pardon is an imputation of guilt, and the acceptance a confession of it.
