I'm struggling to find a comparison of includes() and preload() for ActiveRecord objects. Can anyone explain the difference ?
Asked
Active
Viewed 2.0k times
2 Answers
90
Rails has 2 ways of avoiding the n+1 problem. One involves creating a big join based query to pull in your associations, the other involves making a separate query per association.
When you do includes rails decides which strategy to use for you. It defaults to the separate query approach (preloading) unless it thinks you are using the columns from the associations in you conditions or order. Since that only works with the joins approach it uses that instead.
Rails' heuristics sometimes get it wrong or you may have a specific reason for preferring one approach over the other. preload ( and its companion method eager_load) allow you to specify which strategy you want rails to use.
Frederick Cheung
- 83,189
- 8
- 152
- 174
-
Awesome - a murky, undocumented corner of ActiveRecord that one. Thanks for shining some light ! – Phantomwhale Aug 15 '12 at 05:57
-
6This blog discusses the same topic http://blog.bigbinary.com/2013/07/01/preload-vs-eager-load-vs-joins-vs-includes.html – Nick Vanderbilt Jul 04 '13 at 18:11
-
4This blog post is very useful and clear http://blog.arkency.com/2013/12/rails4-preloading/ – Mahmoud Khaled Jun 10 '14 at 10:14
-
Awesome explanation. Thanks alot! – Mohsin Sethi Sep 10 '20 at 11:36
-7
As apidoc said "This method is deprecated or moved on the latest stable version. The last existing version (v3.0.9) is shown here." So the difference is that includes just NOT deprecated.
freeze
- 546
- 6
- 16
-
6'deprecated or moved'. In this case it's moved, not deprecated. And they're not the same. – Frederick Cheung Aug 14 '12 at 07:03
-
Sorry, but if I have possibility to call it (Rails 3.2.6) it doesn't moved for me - just deprecated. – freeze Aug 14 '12 at 08:40
-
4apidoc gets massively confused when people refactor code from one module to another - it can think that a method has moved even through from the public api point of view it hasn't – Frederick Cheung Aug 14 '12 at 11:16