> Consider the example you mentioned; It seems likely that users would be > interested in "August 2011 Orders" sometime in September, or later. It > would also be likely that they would want to compare August with the > results from August of the prior year. > > Using data mining techniques these statistics could be provided > retroactively, and it would also be possible to update the statistics on > a completely separate process or even a separate server leaving your > primary application servers free to serve user requests. >
Rob This was my starting position, i.e. download a load of data into some other tool (excel) and do the analysis there. I am looking for more real-time counters that can be used for a dashboard to graph order volumes and so forth so I really want it to be performant. Every time the user goes to order statistics I do not want to have to do a huge amount of DB access. > There are several gems that provide the infrastructure to build > something like what I described. For example Github created their own > solution, which they have open sourced called Resque: > > https://github.com/defunkt/resque > > This would also provide you the rake task for resetting, which would > just enqueue another Resque job that you create. > Resque is a background job queue, I currently use delayed_job for sending emails. Unless I am mistaken I am not sure this is really much help. I am not expecting to have to run the reset task that often so running it from the command line will suffice. > -- > Posted viahttp://www.ruby-forum.com/. -- 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.
