When learning rails many years ago, it seemed that understanding and avoiding n+1 queries was both a right of passage and an all-too-common interview question. Fast forward to 2020, and rails still makes it so easy to write, and most learning in a void will still not understand until they hook up a …

Yes, this also bugs me. Imo something like Goldiloader should be part of Rails core. We’re using it in production since years and it makes Rails feeling much railsier (Rails doing the right thing be default).

This feature has been proposed at least twice recently: https://github.com/rails/rails/pull/34843 and https://github.com/rails/rails/pull/33527 . Both closed as stale though :man_shrugging:t2:

@tenderlove @rafaelfranca thoughts on Goldiloader’s and ar_lazy_preload’s designs? What might be the gotchas of shipping something like that as part of default Rails?

Not sure if this solves what you’re looking for, but I was excited to see it get merged. I’d love it on by default. https://github.com/rails/rails/pull/37400

OMG! I have wanted something like that badly for a while. How exciting!

Definitely a potential solution, but it should be the default, with lazy loading being the override option. Thanks for pointing it out!

There is also the jit_preloader gem that takes a slightly different approach to goldiloader and has some additional features on top of it as well

I haven’t looked at the gem internals closely. Just from reading the README, it seems fine, but I don’t know enough to make an informed judgement :sweat_smile:

@nickbender -- use bullet ! it’s still amazing prefetching at default :-1:

N+1 Queries should be the exception, not the easy trap to fall in

A May Of WTFs

jaredcwhite (Jared White) May 8, 2020, 2:13pm 3

Thanks for that resource, I hadn’t tried that gem before. Totally going to give it a spin!

Topic		Replies	Views
Rails N+1 queries auto-detection with zero false positives / false negatives rubyonrails-talk	2	1279	February 26, 2021
[Screencast] Eager Loading with Goldiloader rubyonrails-talk	0	172	May 23, 2016
Plugin to kill N+1 queries rubyonrails-talk	0	132	August 17, 2009
Rails 4.1.2 Eager Load Doesn't Kill N+1 Query rubyonrails-core	1	181	September 22, 2014
better generalized n+1 queries avoidance strategy for the future? rubyonrails-core	1	263	May 6, 2013

N+1 Queries should be the exception, not the easy trap to fall in

Related topics

More Resources