From 7dcedeabbe571de8121a598609c82423bbc8024c Mon Sep 17 00:00:00 2001 From: simonbrandhof Date: Wed, 8 Dec 2010 09:21:35 +0000 Subject: SONAR-2037 The index on 'measure_data.snapshot_id' is needed for DB performance --- .../167_add_index_to_measure_data_snapshot.rb | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sonar-server/src/main/webapp/WEB-INF/db/migrate/167_add_index_to_measure_data_snapshot.rb (limited to 'sonar-server') diff --git a/sonar-server/src/main/webapp/WEB-INF/db/migrate/167_add_index_to_measure_data_snapshot.rb b/sonar-server/src/main/webapp/WEB-INF/db/migrate/167_add_index_to_measure_data_snapshot.rb new file mode 100644 index 00000000000..3eb65808165 --- /dev/null +++ b/sonar-server/src/main/webapp/WEB-INF/db/migrate/167_add_index_to_measure_data_snapshot.rb @@ -0,0 +1,30 @@ +# +# Sonar, entreprise quality control tool. +# Copyright (C) 2009 SonarSource SA +# mailto:contact AT sonarsource DOT com +# +# Sonar is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 3 of the License, or (at your option) any later version. +# +# Sonar is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public +# License along with Sonar; if not, write to the Free Software +# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02 +# + +# +# Sonar 2.5 +# +class AddIndexToMeasureDataSnapshot < ActiveRecord::Migration + + def self.up + add_index :measure_data, :snapshot_id, :name => 'm_data_sid' + end + +end -- cgit v1.2.3