diff options
author | Yorick Peterse <yorickpeterse@gmail.com> | 2016-01-06 19:27:47 +0300 |
---|---|---|
committer | Yorick Peterse <yorickpeterse@gmail.com> | 2016-01-07 16:53:02 +0300 |
commit | 7a240397afc56ab366b6c3504761fbf531b78ec1 (patch) | |
tree | e2f068cdb2f0558b0f0fc7c382ddef49961a1640 /db/migrate/20160106162223_add_index_milestones_title.rb | |
parent | 61561a9eeb1dbb8273a1e8c8a5f37c0c01917c99 (diff) |
Added an index on milestones.title
Certain pages (e.g. the group wide issues page) filter miletones by
their title. Without an index this will result in a sequence scan on a
large dataset increasing the total loading time of a page.
Diffstat (limited to 'db/migrate/20160106162223_add_index_milestones_title.rb')
-rw-r--r-- | db/migrate/20160106162223_add_index_milestones_title.rb | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate/20160106162223_add_index_milestones_title.rb b/db/migrate/20160106162223_add_index_milestones_title.rb new file mode 100644 index 00000000000..767885e2aac --- /dev/null +++ b/db/migrate/20160106162223_add_index_milestones_title.rb @@ -0,0 +1,5 @@ +class AddIndexMilestonesTitle < ActiveRecord::Migration + def change + add_index :milestones, :title + end +end |