Eager loading kills the :select clause in ActiveRecord

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

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


Rails Wheels - Find Plugins, List & Sell Plugins -
http://railswheels.com