When an instance has a lot of activity, the default sort of hot posts mostly shows the posts with the highest scores. This change allows an administrator to load a custom hot sort function defined in SQL into the database and use it for hot-sorting posts. A function defined in SQL will be faster than the default hot sort, because the database will be able to use caching and indexing on the calculated "hot" value.
When an instance has a lot of activity, the default sort of hot posts mostly shows the posts with the highest scores. This change allows an administrator to load a custom hot sort function defined in SQL into the database and use it for hot-sorting posts. A function defined in SQL will be faster than the default hot sort, because the database will be able to use caching and indexing on the calculated "hot" value.