Speed up list page query.

1 files changed, 12 insertions, 0 deletions

diff --git a/db/migrate/066_add_first_letter.rb b/db/migrate/066_add_first_letter.rb
new file mode 100644
index 000000000..7878098e0
--- /dev/null
+++ b/db/migrate/066_add_first_letter.rb
@@ -0,0 +1,12 @@
+class AddFirstLetter < ActiveRecord::Migration
+    def self.up
+        add_column :public_bodies, :first_letter, :string
+        add_index :public_bodies, :first_letter
+        PublicBody.update_all "first_letter = upper(substr(name, 1, 1))"
+        change_column :public_bodies, :first_letter, :string, :null => false
+    end
+
+    def self.down
+        remove_column :public_bodies, :first_letter
+    end
+end