From 7a240397afc56ab366b6c3504761fbf531b78ec1 Mon Sep 17 00:00:00 2001 From: Yorick Peterse Date: Wed, 6 Jan 2016 17:27:47 +0100 Subject: 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. --- db/migrate/20160106162223_add_index_milestones_title.rb | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 db/migrate/20160106162223_add_index_milestones_title.rb (limited to 'db/migrate') 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 -- cgit v1.2.3