]> cat aescling's git repositories - mastodon.git/commit
Fix PostgreSQL load when linking in announcements (#13250)
authorThibG <thib@sitedethib.com>
Sun, 5 Apr 2020 10:51:22 +0000 (12:51 +0200)
committerGitHub <noreply@github.com>
Sun, 5 Apr 2020 10:51:22 +0000 (12:51 +0200)
commit89e28c76744dc888e7c5f85aef305452681fd6be
treea8912717fa31375c5898786e370ed022e3c43c5c
parenta889756dd5f72a1423a613d8ce141f5347da48bc
Fix PostgreSQL load when linking in announcements (#13250)

* Fix PostgreSQL load when linking in announcements

Fixes #13245 by caching status lookups

Since statuses are supposed to be known already and we only
need their URLs and a few other things, caching them should
be fine.

Since it's only used by announcements so far, there won't
be much statuses to cache.

* Perform status lookup when saving announcements, not when rendering them

* Change EntityCache#status to fetch URLs instead of looking into the database

* Move announcement link lookup to publishing worker

* Address issues pointed out during review
app/lib/entity_cache.rb
app/models/announcement.rb
app/models/status.rb
app/workers/publish_scheduled_announcement_worker.rb
db/migrate/20200312162302_add_status_ids_to_announcements.rb [new file with mode: 0644]
db/schema.rb