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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---

