From 31597fd37717db79edb69a64c97b1dca2f9a8a08 Mon Sep 17 00:00:00 2001 From: Eugen Rochko Date: Fri, 7 Apr 2017 00:04:09 +0200 Subject: Low-hanging fruit of query optimization, these indices were missing --- .../20170406215816_add_notifications_and_favourites_indices.rb | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 db/migrate/20170406215816_add_notifications_and_favourites_indices.rb (limited to 'db/migrate/20170406215816_add_notifications_and_favourites_indices.rb') diff --git a/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb b/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb new file mode 100644 index 000000000..00e41bf3a --- /dev/null +++ b/db/migrate/20170406215816_add_notifications_and_favourites_indices.rb @@ -0,0 +1,7 @@ +class AddNotificationsAndFavouritesIndices < ActiveRecord::Migration[5.0] + def change + add_index :notifications, [:activity_id, :activity_type] + add_index :accounts, :url + add_index :favourites, :status_id + end +end -- cgit