Trevor Squires
2005-Apr-19 22:18 UTC
eager associations still hitting database for associations?
Hi, I''m just trying out the new :include eager associations stuff and in my development log it shows (for a has_many relationship) a) that it''s now doing a left outer join b) it''s till doing a select * on my associated tables when I iterate through the association data is anyone else seeing this? Thanks, Trevor
Michael Koziarski
2005-Apr-20 00:31 UTC
Re: eager associations still hitting database for associations?
On 4/20/05, Trevor Squires <trevor-k8q5a0yEZAgS+FvcfC7Uqw@public.gmane.org> wrote:> Hi, > > I''m just trying out the new :include eager associations stuff and in my > development log it shows (for a has_many relationship) > > a) that it''s now doing a left outer join > b) it''s till doing a select * on my associated tables when I iterate > through the association data > > is anyone else seeing this?Eager associations have worked quite well for me and I''m certainly not seeing this in my cases. Could you please post the code that''s causing it? Perhaps we need to raise a ticket> Thanks, > Trevor > > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails >-- Cheers Koz
Trevor Squires
2005-Apr-20 04:09 UTC
Re: eager associations still hitting database for associations?
Thanks Michael, as luck would have it, this was a known issue and corrected in 0.12.1 Trevor On 19-Apr-05, at 5:31 PM, Michael Koziarski wrote:> On 4/20/05, Trevor Squires <trevor-k8q5a0yEZAgS+FvcfC7Uqw@public.gmane.org> wrote: >> Hi, >> >> I''m just trying out the new :include eager associations stuff and in >> my >> development log it shows (for a has_many relationship) >> >> a) that it''s now doing a left outer join >> b) it''s till doing a select * on my associated tables when I iterate >> through the association data >> >> is anyone else seeing this? > > Eager associations have worked quite well for me and I''m certainly not > seeing this in my cases. > > Could you please post the code that''s causing it? Perhaps we need to > raise a ticket > >> Thanks, >> Trevor >> >> _______________________________________________ >> Rails mailing list >> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org >> http://lists.rubyonrails.org/mailman/listinfo/rails >> > > > -- > Cheers > > Koz > _______________________________________________ > Rails mailing list > Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org > http://lists.rubyonrails.org/mailman/listinfo/rails
Florian Groß
2005-Apr-20 17:15 UTC
Re: eager associations still hitting database for associations?
Trevor Squires wrote:> Hi, > > I''m just trying out the new :include eager associations stuff and in my > development log it shows (for a has_many relationship) > > a) that it''s now doing a left outer join > b) it''s till doing a select * on my associated tables when I iterate > through the association data > > is anyone else seeing this?Yup, I''m still seeing this for has_and_belongs_to_many relations in 0.12.1. I''ll have a deeper look at tracing what is going on inside Rails later, I guess.