tiger-swallowtails-2013/iPark — pull request #79 by nathanallen (2013-10-25 03:22:19+00:00)
Title: Optimize db

before_indexing
--------------------------
Completed 200 OK in 4296ms (Views: 0.1ms | ActiveRecord: 3909.5ms)
Completed 200 OK in 4717ms (Views: 0.1ms | ActiveRecord: 4359.9ms)
Completed 200 OK in 4705ms (Views: 0.1ms | ActiveRecord: 4402.5ms)
Completed 200 OK in 4769ms (Views: 0.1ms | ActiveRecord: 4411.3ms)
Completed 200 OK in 4674ms (Views: 0.1ms | ActiveRecord: 4324.6ms)

add_index(:spots, :zip_code)
--------------------------
Completed 200 OK in 4808ms (Views: 0.1ms | ActiveRecord: 4392.1ms)
Completed 200 OK in 4732ms (Views: 0.1ms | ActiveRecord: 4384.5ms)
Completed 200 OK in 4736ms (Views: 0.1ms | ActiveRecord: 4426.2ms)
Completed 200 OK in 4811ms (Views: 0.1ms | ActiveRecord: 4449.8ms)
Completed 200 OK in 4663ms (Views: 0.1ms | ActiveRecord: 4312.2ms)

add_index(:reservations, :date)
--------------------------
Completed 200 OK in 837ms (Views: 0.1ms | ActiveRecord: 192.8ms)
Completed 200 OK in 697ms (Views: 0.1ms | ActiveRecord: 177.1ms)
Completed 200 OK in 630ms (Views: 0.1ms | ActiveRecord: 170.5ms)
Completed 200 OK in 657ms (Views: 0.1ms | ActiveRecord: 167.7ms)
Completed 200 OK in 701ms (Views: 0.1ms | ActiveRecord: 180.4ms)