thunderbird / addons-server

🕶 addons.thunderbird.net Django app and API, forked from addons.mozilla.org 🎉
https://addons.thunderbird.net
BSD 3-Clause "New" or "Revised" License
18 stars 17 forks source link

Fix deliver_hotness performance #299

Open Sancus opened 2 months ago

Sancus commented 2 months ago

This function, which calculates the "up & coming" add-ons, has serious perf problems which impacts stability of the web servers.

They have been fixed upstream: https://github.com/mozilla/addons-server/pull/14913 (though it seems other changes have been made such as using google bigquery so this patch may not be as helpful).

The value of the filter itself seems dubious to me(does it even work right?), so I'm disabling that cron task until we backport the patch or the Python3 upgrade + upstream catchup takes care of it. Disabled here: https://github.com/thunderbird/thundernest-ansible/commit/4c1bfd25c445a5c6f2c054a905d877627f7b6143