#372 Bullet

Aug 09, 2012 | 6 minutes | Performance, Plugins

Bullet will notify you of database queries that can potentially be improved through eager loading or counter cache column. A variety of notification alerts are supported.

Click to Play Video ▶

Download:
source codeProject Files in Zip (55.7 KB)
mp4Full Size H.264 Video (17.4 MB)
m4vSmaller H.264 Video (7.75 MB)
webmFull Size VP8 Video (10 MB)
ogvFull Size Theora Video (16.6 MB)

Browse Source Code

Resources

Bullet

          terminal
        
rails g migration add_products_count_to_categories products_count:integer
rails g migration cache_products_count
rake db:migrate

          Gemfile
        
gem 'bullet', group: :development

          config/initializers/bullet.rb
        
if defined? Bullet
  Bullet.enable = true
  # Bullet.alert = true
  Bullet.bullet_logger = true
end

          categories_controller.rb
        
def index
  @categories = Category.order(:name).includes(:products)
end

          db/migrate/cache_products_count.rb
        
class CacheProductsCount < ActiveRecord::Migration
  def up
    execute "update categories set products_count=(select count(*) from products where category_id=categories.id)"
  end

  def down
  end
end