I'm in the midst of a Rails application that produces line,bar, and
pie charts for constantly accumulated data. That said, I'm looking
for some quality ways in which to deal with presenting the large
amounts of data while keeping the graphs accurate and up to date.
Obviously the simple answer is to build and run a new query each and
every time a chart is accessed. However, my gut tells me that there
are frameworks/libraries, etc. that can manage this -- perhaps in the
background. Any thoughts?
For the record, I am using XMLSWF charts (http://www.maani.us/