#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)

Braden Schaeffer over 12 years ago

Why would you try to avoid ActiveRecord in migrations when your migration is an ActiveRecord::Migration class?

Brent over 12 years ago

+1, I'm curious to hear more about why Ryan prefers writing SQL within migrations.

Sergey Alekseev over 11 years ago

Specifying a counter cache will add it to that model’s list of readonly attributes using attr_readonly.

I think raw SQL within migration is the only option to update counter cache column.

Sergey Alekseev over 11 years ago

Sorry, we can use .reset_counters:
Category.all.map(&:id).each { |id| Category.reset_counters(id, :products) }

Andrew Vit over 12 years ago

When you step through migration steps, your model class might not correspond to the fields in the database for previous migrations. Let's say at a later point you change the model, and this older migration needs to run, it might fail because you've added validation logic or subsequently altered/removed a column that it's trying to migrate.

Brent over 12 years ago

Makes sense, thanks Andrew.

Corey Innis over 11 years ago

Exactly right. This why, if I "must" use AR in a migration, I prefer to redefine (much simplified) classes within the migration file... ensuring that the AR class definitions match the db schema.

Also, for large datasets, executing SQL rather than instantiating AR records can mean your migration runs in seconds rather than minutes/hours.

Rubem Azenha over 12 years ago

Very nice! It would be even nicer if it did something like the miniprofiler showed in episode #368 and display a small expandable box in the corner of your web page with the info about slow queries.

elsiemkcee about 10 years ago

Oh yes...Even I was thinking on the same lines!!!

Andrew Vit over 12 years ago

Does this gem do query_trace style logging? What's the current fancy option for that?

memoht over 12 years ago

I enjoyed this episode, though the second migration to populate counts for previous records didn't seem to go over so well when I ran it on Heroku. I ended up rolling back the second migration.

noctivityinc about 12 years ago

How can you fix n + 1 queries on a has :through association?

Geoffroy Montel over 11 years ago

Thanks ! Just used it today and the gem found a good optimization !

razvan-pavel almost 11 years ago

Can I enable/disable the alerts only for some paths/controllers ?
I got a lot of alerts on activeadmin and I cannot change that code.
For example I get one for the column :user_type line:

          app/admin/admin_users.rb
        
  index do
    column :email
    column :first_name
    column :last_name
    column :user_type

    default_actions
  end

Sebastian Wramba over 10 years ago

If it's not too late: The GitHub page has a section "Whitelist" where it is explained how you can add third-party gems you want to exclude.

Download App about 7 years ago

Great post.

Pierre GD almost 7 years ago

Thanks for this

Download App about 7 years ago

Somebody already provided this thing.