Fix stop_areas#index memory issue + slow query

Refs #1607

2 files changed, 7 insertions, 1 deletions

diff --git a/db/migrate/20160909130810_add_index_to_stop_areas.rb b/db/migrate/20160909130810_add_index_to_stop_areas.rb
new file mode 100644
index 000000000..e5d4d2f40
--- /dev/null
+++ b/db/migrate/20160909130810_add_index_to_stop_areas.rb
@@ -0,0 +1,5 @@
+class AddIndexToStopAreas < ActiveRecord::Migration
+  def change
+    add_index :stop_areas, :name
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 19eeab9e7..0e606fb3e 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20160909125235) do
+ActiveRecord::Schema.define(version: 20160909130810) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -504,6 +504,7 @@ ActiveRecord::Schema.define(version: 20160909125235) do
     t.datetime "deleted_at"
   end
 
+  add_index "stop_areas", ["name"], :name => "index_stop_areas_on_name"
   add_index "stop_areas", ["objectid"], :name => "stop_areas_objectid_key", :unique => true
   add_index "stop_areas", ["parent_id"], :name => "index_stop_areas_on_parent_id"
   add_index "stop_areas", ["stop_area_referential_id"], :name => "index_stop_areas_on_stop_area_referential_id"