Ruby on Rails Friday, February 25, 2011

Hi Fred,

Yes I am pretty sure, because I write it out using to_sql before I run.  At the moment is seems like a Windows memory problem rather than a ruby problem.  As I commented on the StackOverflow thread I now have a solution for my immediate problem. Since I am calculating averages over a date range over three years - and since the dates are actually end-of-month dates - I am really calculating an overage over 36 distinct months.  I therefore do my query in two steps.  First, I calculate averages and counts per month.  Second I aggregate up to get averages over 36 months.  Runs pretty quick.

But I haven't solved the problem and I haven't been able to find comments from anyone else experiencing the same thing.  So the mystery remains.

Ruby-prof, though.  Thanks for that.  You made me install it and its actually rather nice.

William

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

No comments:

Post a Comment