Sunday, February 3, 2013
hi andreo, thanks for reply
-- answer you inline
On Sun, Feb 3, 2013 at 7:04 AM, <andreo@benjamin.dk> wrote:
HI william,how exactly does chrome prompt that?
Uniform Notifier activities:551user: william N+1 Query detected Activity => [:activity_type] Add to your finder: :include => [:activity_type] N+1 Query method call stack /home/william/work/lly/app/views/activities/index.html.erb:48:in `block in _app_views_activities_index_html_erb___3943997569956187419_46069520' /home/william/work/lly/app/views/activities/index.html.erb:32:in `_app_views_activities_index_html_erb___3943997569956187419_46069520'
line 48
<li><div id="type"></div>类型: <%= hot_activity.activity.activity_type.name %></li>
line 32
<li><div id="type"></div>类型: <%= hot_activity.activity.activity_type.name %></li>
whats the view like?
<% @hot_activities.each_with_index do |hot_activity, index| %>
<div id="detail<%= index + 1 %>" class="detail cf">
<ul>
<li class="header">
<%= link_to hot_activity.activity.title, activity_path(hot_activity.activity) %>
</li>
<li>
<div id="date"></div>
...
is that the only line you have on your controller?
def index
@hot_activities = HotActivity.includes(:activity)
.where("activities.status = 'open'")
.order('start_at ASC')
.limit(5)
@closed_activities = Activity.includes(:participants)
.where("status = 'closed'")
.order("participants_count desc")
.limit(5)
@hot_sponsors = User.includes(:created_activities)
.where("status = 'A'")
.order("created_activities_count desc")
.limit(8)
end
can you be a little more specific and post exactly what is the error you get.all the best,Andre--
On Friday, 1 February 2013 10:06:40 UTC+1, William Herry wrote:I have three class,HotActivity, Activity和ActivityType
HotActivity and Activity is one to one association, Activity belongs to ActivityType
in controller I code like this
@hot_activities = HotActivity.includes(:activity)chrome will prompt me this
user: william N+1 Query detected Activity => [:activity_type] Add to your finder: :include => [:activity_type] N+1 Query method call stackif I add like this
@hot_activities = HotActivity.includes(:activity => :activity_type)it prompt this
user: william Unused Eager Loading detected HotActivity => [:activity] Remove from your finder: :include => [:activity] activities:575 Uniform Notifier activities:587 user: william Unused Eager Loading detected Activity => [:activity_type] Remove from your finder: :include => [:activity_type]some one please help,thanks in advs
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/iHKLLzvtewoJ.
For more options, visit https://groups.google.com/groups/opt_out.
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment