[
https://issues.apache.org/jira/browse/OLIO-56?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
William Sobel resolved OLIO-56.
-------------------------------
Resolution: Fixed
Indexing was in place, only address zip index was missing. This shouldn't have
made a large difference. Addeding one index.
Author: wsobel
Date: Thu Feb 26 19:37:02 2009
New Revision: 748281
URL: http://svn.apache.org/viewvc?rev=748281&view=rev
Log:
OLIO-56: Added indexes for address zip code
Added:
incubator/olio/webapp/rails/trunk/db/migrate/20090226193152_improve_indexes.rb
Added:
incubator/olio/webapp/rails/trunk/db/migrate/20090226193152_improve_indexes.rb
URL:
http://svn.apache.org/viewvc/incubator/olio/webapp/rails/trunk/db/migrate/20090226193152_improve_indexes.rb?rev=748281&view=auto
==============================================================================
---
incubator/olio/webapp/rails/trunk/db/migrate/20090226193152_improve_indexes.rb
(added)
+++
incubator/olio/webapp/rails/trunk/db/migrate/20090226193152_improve_indexes.rb
Thu Feb 26 19:37:02 2009
@@ -0,0 +1,9 @@
+class ImproveIndexes < ActiveRecord::Migration
+ def self.up
+ add_index :addresses, :zip
+ end
+
+ def self.down
+ remove_index :addresses, :zip
+ end
+end
> Improve indexing in ROR application.
> ------------------------------------
>
> Key: OLIO-56
> URL: https://issues.apache.org/jira/browse/OLIO-56
> Project: Olio
> Issue Type: Improvement
> Components: rails-app
> Reporter: William Sobel
> Assignee: William Sobel
>
> The current indexing may account for some performance problems in the Rails
> application. We will revisit the indexing currently in the application and
> make sure we have sufficient foreign key indexes.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
