diff options
| author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2009-10-25 16:56:46 +0000 |
|---|---|---|
| committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2009-10-25 16:56:46 +0000 |
| commit | 06fff6295cecd8f1a9186ab740fd9542035c18ba (patch) | |
| tree | 18517bdca6a297d5eafe57f6bdde579fee2c1654 /db | |
| parent | 9aa2b6b9a46427a8b9611231d672fab9df127e3e (diff) | |
| download | redmine-06fff6295cecd8f1a9186ab740fd9542035c18ba.tar.gz redmine-06fff6295cecd8f1a9186ab740fd9542035c18ba.zip | |
Add indexes on various timestamps to speed up the activity view.
git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2981 e93f8b46-1217-0410-a6f0-8f06a7374b81
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20091025163651_add_activity_indexes.rb | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/db/migrate/20091025163651_add_activity_indexes.rb b/db/migrate/20091025163651_add_activity_indexes.rb new file mode 100644 index 000000000..f18059316 --- /dev/null +++ b/db/migrate/20091025163651_add_activity_indexes.rb @@ -0,0 +1,25 @@ +class AddActivityIndexes < ActiveRecord::Migration + def self.up + add_index :journals, :created_on + add_index :changesets, :committed_on + add_index :wiki_content_versions, :updated_on + add_index :messages, :created_on + add_index :issues, :created_on + add_index :news, :created_on + add_index :attachments, :created_on + add_index :documents, :created_on + add_index :time_entries, :created_on + end + + def self.down + remove_index :journals, :created_on + remove_index :changesets, :committed_on + remove_index :wiki_content_versions, :updated_on + remove_index :messages, :created_on + remove_index :issues, :created_on + remove_index :news, :created_on + remove_index :attachments, :created_on + remove_index :documents, :created_on + remove_index :time_entries, :created_on + end +end |