diff options
| author | ThibG <thib@sitedethib.com> | 2020-04-05 12:51:22 +0200 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-04-05 12:51:22 +0200 |
| commit | 89e28c76744dc888e7c5f85aef305452681fd6be (patch) | |
| tree | a8912717fa31375c5898786e370ed022e3c43c5c /db/migrate | |
| parent | a889756dd5f72a1423a613d8ce141f5347da48bc (diff) | |
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
Diffstat (limited to 'db/migrate')
| -rw-r--r-- | db/migrate/20200312162302_add_status_ids_to_announcements.rb | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/db/migrate/20200312162302_add_status_ids_to_announcements.rb b/db/migrate/20200312162302_add_status_ids_to_announcements.rb new file mode 100644 index 000000000..42aa6513d --- /dev/null +++ b/db/migrate/20200312162302_add_status_ids_to_announcements.rb @@ -0,0 +1,6 @@ +class AddStatusIdsToAnnouncements < ActiveRecord::Migration[5.2] + def change + add_column :announcements, :status_ids, :bigint, array: true + end +end + |