about summary refs log tree commit diff
path: root/db/migrate
diff options
context:
space:
mode:
authorThibG <thib@sitedethib.com>2020-04-05 12:51:22 +0200
committerGitHub <noreply@github.com>2020-04-05 12:51:22 +0200
commit89e28c76744dc888e7c5f85aef305452681fd6be (patch)
treea8912717fa31375c5898786e370ed022e3c43c5c /db/migrate
parenta889756dd5f72a1423a613d8ce141f5347da48bc (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.rb6
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
+