I can see how to do eager loading of associations in the cases where
you''re letting AR construct the SQL and passing in :include
=>{:assoc1,:assoc2} and so on. But my case using LEFT OUTER JOIN it
generates is mind numbingly slow so I have to hand code my SQL to get an
acceptable speed. But doing this means that I can''t see how to get the
thing to eager load.
The issue is that I have and M2M relationship. model_1 and model_2 both
have a mutual HABTM relationship. When I select all instances of model_1
that are linked to a particular instance of model_2 I also want to see
for each instance of model_1 all the instances of model_2 that it''s
linked to. I can see how to generate such a query by hand coding, and
the result set will be something like
model_1.id,model_1.field_1, model_1.field_2, model_2.id,model_2.field_1
1 avalue anothervalue 20 m2_value
1 avalue anothervalue 650
m2_different_value
1 avalue anothervalue 785
m2_another_different_value
and so on. Now that''s the kind of result set that AR must be getting
back when it automagically creates SQL for eager loading. So how does it
work out to creating 3 instances of model_2 linked to one instance of
model_1 from the above result set?
To eager load the associations given the above result set does AR need
to know that the input parameters had an :include in them. Or does it
work things out purely from the result set?
If it can work purely from a result set then I''ll be able to hand code
the SQL. If I have to tap on :include =>{:something} into automagic SQL
creation then I''m stuffed.
Any thoughts?
John Small
--
Posted via http://www.ruby-forum.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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
On 27 Sep 2008, at 14:28, John Small> To eager load the associations given the above result set does AR need > to know that the input parameters had an :include in them. Or does it > work things out purely from the result setIt''s not by inspection of the result set (although it does used a certain well defined set of aliased column names. There''s a plugin called eager finder SQL that claims to allow eager loading with custom SQL. Fred> > > > > If it can work purely from a result set then I''ll be able to hand code > the SQL. If I have to tap on :include =>{:something} into automagic > SQL > creation then I''m stuffed. > > Any thoughts? > > John Small > -- > Posted via http://www.ruby-forum.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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Frederick Cheung wrote:> It''s not by inspection of the result set (although it does used a > certain well defined set of aliased column names. There''s a plugin > called eager finder SQL that claims to allow eager loading with custom > SQL. > > FredPerfect, just what I''m looking for. Thanks John Small -- Posted via http://www.ruby-forum.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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---