Is there a method for forcing a join-based strategy?
On Nov 3, 2:09 am, Artūras Šlajus <[email protected]>
wrote:
> Frederick Cheung wrote:
> > On Nov 2, 10:56 pm, Art ras lajus <[email protected]>
> > wrote:
>
> >> Now the evil thing is, that even thou' :include is specified, it does
> >> nothing. New AR eager loading resorts to doing n+1 sql queries in
> >> FowSsEntry.for(1,1).each { |fse| fse.solar_system }
>
> >> How do I force it into joining my table, without impacting my SQL
> >> performance?
>
> > Is the issue the fact that :include does not always trigger a join
> > based strategy ? What are the actual sql queries you see?
>
> Yes.
>
> I see this:
> [2009-11-03 00:35:26|main|debug] FowSsEntry Load (0.0ms) SELECT * FROM
> `fow_ss_entries` WHERE (`fow_ss_entries`.`galaxy_id` = 1 AND
> `fow_ss_entries`.`player_id` = 1)
> [2009-11-03 00:35:26|main|debug] SolarSystem Load (0.0ms) SELECT * FROM
> `solar_systems` WHERE (`solar_systems`.`id` = 57)
> [2009-11-03 00:35:26|main|debug] SolarSystem Load (0.0ms) SELECT * FROM
> `solar_systems` WHERE (`solar_systems`.`id` = 157)
> [2009-11-03 00:35:26|main|debug] SolarSystem Load (0.0ms) SELECT * FROM
> `solar_systems` WHERE (`solar_systems`.`id` = 313)
> [2009-11-03 00:35:26|main|debug] SolarSystem Load (0.0ms) SELECT * FROM
> `solar_systems` WHERE (`solar_systems`.`id` = 314)
>
> Which is kind of bad ;(
>
> --
> Posted viahttp://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 [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
-~----------~----~----~----~------~----~------~--~---
