dear rubyist
as a subject, eager loading query saya nggak jalan, nggak tau kenapa
padahal sy merasa query yg dilakukan udah benar
sy melakukan query ini seperti ini di controller
@searches = Search.find(:all,:conditions => {:alumni_id =>
params[:id]},:include => [:course,:university,:alumni])
tapi di development.log tetap saja menghasilkan 4x query ~_~
Search Load (0.4ms) SELECT * FROM `searches` WHERE
(`searches`.`alumni_id` = '2053932786')
Search Columns (2.3ms) SHOW FIELDS FROM `searches`
Course Columns (1.2ms) SHOW FIELDS FROM `courses`
Course Load (0.7ms) SELECT * FROM `courses` WHERE (`courses`.`id` =
298486374)
University Columns (2.5ms) SHOW FIELDS FROM `universities`
University Load (0.2ms) SELECT * FROM `universities` WHERE
(`universities`.`id` = 2053932785)
Alumni Columns (2.0ms) SHOW FIELDS FROM `alumnis`
Alumni Load (0.3ms) SELECT * FROM `alumnis` WHERE (`alumnis`.`id` =
2053932786)
association di model pun sy kira sudah betul
class Alumni < ActiveRecord::Base
has_many :searches
end
class University < ActiveRecord::Base
has_many :searches
end
class Course < ActiveRecord::Base
has_many :searches
end
class Search < ActiveRecord::Base
belongs_to :alumni
belongs_to :university
belongs_to :course
end
sedanngkan rhtmlnya seperti ini
<% @searches.each_with_index do |s,idx|%>
<p>
<b>No :</b> <%= idx+1 %>
</p>
<p>
<b>Course:</b>
<%=h s.course.name %>
</p>
<p>
<b>University:</b>
<%=h s.university.name %>
</p>
<p>
<b>Year of Passing:</b>
<%=h s.year %>
</p>
<% end %>
ini kira2 kenapa ya ? ada yg tau ?
versi ruby & rails yg dipake
adit$ rails -v
Rails 2.3.3
adit$ ruby -v
ruby 1.8.7 (2009-06-12 patchlevel 174) [i686-darwin9]
regards
Aditya
--
blog : http://adityakircon.blogsome.com
ym : kirconboy
skype : adit_skype
i continue to fight, i continue to FIGHT (O2 - Orange Range)
[Non-text portions of this message have been removed]
