Do you have indexes on your database tables at all? On Fri, Feb 25, 2011 at 7:42 AM, William Fisk <[email protected]>wrote:
> 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 [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. > -- 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.
