Re: Duplicate queries while eager loading multiple associations

[Frederick Cheung]

On Monday, September 17, 2012 2:45:05 AM UTC+1, Dennis Krupenik wrote:

Hello all,

given the following models and console log: https://gist.github.com/3735116

I do not understand why the latter statements (o.order_items and o.total) yield sql queries.

Have I missed something in AR documentation? What should be done to get rid of redundant sql queries?

oi = o.order_items.includes(item: :photos) 

does not mutate o.order_items, adding the includes to it: it returns a new array of objects that has the extra options applied. 

You do o = Order.includes(order_items: {item: photos}).last in which case

o.order_items should  not execute any queries

Fred

[Dennis Krupenik]

thanks a lot, that did it