incubator-olio-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "William Sobel (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (OLIO-56) Improve indexing in ROR application.
Date Thu, 26 Feb 2009 19:39:04 GMT

     [ 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.


Mime
View raw message