diff options
| author | Eugen Rochko <eugen@zeonfederated.com> | 2017-04-07 00:04:09 +0200 |
|---|---|---|
| committer | Eugen Rochko <eugen@zeonfederated.com> | 2017-04-07 00:04:38 +0200 |
| commit | 31597fd37717db79edb69a64c97b1dca2f9a8a08 (patch) | |
| tree | 799a9e9c5936afd482ce73edbc89bf6f3488591d /db/migrate/20170406215816_add_notifications_and_favourites_indices.rb | |
| parent | 8cb7d157bd5df803d72499bbb39ac9631189628d (diff) | |
Low-hanging fruit of query optimization, these indices were missing
Diffstat (limited to 'db/migrate/20170406215816_add_notifications_and_favourites_indices.rb')
| -rw-r--r-- | db/migrate/20170406215816_add_notifications_and_favourites_indices.rb | 7 |
1 files changed, 7 insertions, 0 deletions
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 |