Hi all.
I have a sql performance problem. Would be great to get some inspiration.
model hour: id, week_id, :user_id, project_id, hour
controller:
@hours = Hour.project(@project.id)
update:
if params[:booking_user_ids]
params[:booking_user_ids].each do
Hour.update(params[:booking_user].keys,
params[:booking_user].values).reject { |p| p.errors.empty? }
end
end
view:
<% @hours.group_by(&:user_id).sort.each do |user, hours| %>
....
<%= simple_form_for @hour, :url => hour_path, :remote => true, :method =>
:put do %>
<%= render 'form_user', :hours => hours %>
partial:
<% hours.each do |week|%>
<%= fields_for "booking_user[]", week do |w| %>
<%= w.text_field :hour, :class => 'submittable' %>
<%= hidden_field_tag "booking_user_ids[]", w %>
Form entries are stored but on reload it gives me tons of:
CACHE (0.0ms) SELECT `hours`.* FROM `hours` WHERE `hours`.`id` = 189
LIMIT 1
(1.0ms) BEGIN
(0.9ms) COMMIT
and takes 11 seconds
on the second reload is fine 300 milsec.
Any idea to improve that?
Thanks
--
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@googlegroups.com.
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/SpOFNuxGSNgJ.
For more options, visit https://groups.google.com/groups/opt_out.
