Project

eladmeidar/rails_indexes

0.42

Active Record Index Assistants

No commit activity in last 3 years
There's a lot of open issues
eladmeidar/rails_indexesHomepageSource CodeBug TrackerWiki
A rake task to track down missing database indexes. does not assume that all foreign keys end with the convention of _id.
 Popularity
Stars
492
Forks
33
Watchers
9
 Issues
Open Issues
12
Closed Issues
11
Total Issues
23
Issue Closure Rate
47%
 Pull Requests
Open Pull Requests
0
Closed Pull Requests
2
Merged Pull Requests
3
Pull Request Acceptance Rate
60%
 Development
Primary Language
Ruby
Average date of last 50 commits
2010-04-25
 Dependencies
 Project Readme

DEPRECATED

This gem doesn’t really work on Rails 4 – no plans on upgrading it anyway. you probably should take a look at lol_dba

Rails Indexes

Rails indexes is a small package of 2 rake tasks that scan your application models and displays a list of columns that probably should be indexed.

Note: there may be more fields depending on your application design and custom queries.

Rails 3.x and 4.x

If you’re using Rails 3.x or 4.x, you probably should take a look at lol_dba

Installation

as a rails plugin:

script/plugin install git://github.com/eladmeidar/rails_indexes.git

Usage

Display a migration for adding/removing all necessary indexes based on associations:

rake db:index_migration

Display a migration for adding/removing all necessary indexes based on AR::Base#find calls (including: find, find_by, find_all_by, find_by_x_and_y, find_all_by_x_and_y):

rake db:find_query_indexes

Note that it would probably make more sense running those tasks on production, where you actually need those indexes to be added.

Tests

Requires SQLite3 installed, then just:

rake

to run the tests

Author:

Elad Meidar – http://blog.eizesus.com

Thanks:
Eric Davis – http://littlestreamsoftware.com

Released under the same license as Ruby. No Support. No Warranty, no Pain.