You are viewing a plain text version of this content. The canonical link for it is here.
Posted to olio-dev@incubator.apache.org by "William Sobel (JIRA)" <ji...@apache.org> on 2009/02/26 19:39:04 UTC
[jira] Resolved: (OLIO-56) Improve indexing in ROR application.
[ 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.