title: Proper to use stored procedure to dynamically create charts?
body: <p>I am working in rails and would like to add dynamic charts to my app. My thinking was that, given the data is in flat files, a stored procedure could be created in the MySQL db to query the data based on the parameters a user wishes to see, ie. sum users and group by activity they do (y-axis) by the months of the year (x-axis). The stored procedure would then be called from rails and return the result to be built into a chart.</p>
  
  <p>However, it has bee noted that stored procedures are slow and therefore may kill the user experience if there are long loading times to simply render a chart. </p>
  
  <p>For what I am trying to do is this the best way to proceed forward? </p>