Add an index on incoming message id to the outgoing messages table - suspect this will improve the performance of AdminRequestController#destroy_incoming, which looks for outgoing messages by incoming message.

1 files changed, 9 insertions, 0 deletions

diff --git a/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb b/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb
new file mode 100644
index 000000000..893395f41
--- /dev/null
+++ b/db/migrate/20120913074940_add_incoming_message_index_to_outgoing_messages.rb
@@ -0,0 +1,9 @@
+class AddIncomingMessageIndexToOutgoingMessages < ActiveRecord::Migration
+  def self.up
+      add_index :outgoing_messages, :incoming_message_followup_id
+  end
+
+  def self.down
+      remove_index :outgoing_messages, :incoming_message_followup_id
+  end
+end