eager loading kills the :select clause in ActiveRecord

rubyonrails-talk
1

hi

I've dramatically improved my SQL performance with eager loading, but the problem is, it kills the :select directive because it generates its own (it ONLY selects the table fields and eager loaded table fields). Is there a way around this? I have some left outer joins in my :joins clause, and some aliasing in my :select clause, but the :include clause kills the select aliases. any advice?

thanks, dino

2

dino d. wrote:

I've dramatically improved my SQL performance with eager loading, but the problem is, it kills the :select directive because it generates its own (it ONLY selects the table fields and eager loaded table fields). Is there a way around this? I have some left outer joins in my :joins clause, and some aliasing in my :select clause, but the :include clause kills the select aliases. any advice?

Not supported at present, though I have a plugin that makes this work for Rails 2.0.2, not yet ported to 2.1+:

   http://dev.rubyonrails.org/ticket/7147#comment:12

There is another plugin that works with 2.2 that allows you to load object hierarchies when using custom SQL:

   http://rubyforge.org/projects/eagerfindersql