Hi Bill,
This should be feasible. We have users who are doing this sort of analysis/visualization in R with much snappier response times than you're seeing here.
Are you setting up your R script as an R report (Views->Create->R View) or through some other mechanism?
Do you know where the bottleneck is? It could be in querying the data from the database, writing it to the R script, running the R script itself, or marshalling the results to send back to the browser. Looking at CPU usage may be enough to determine which stage it's happening at, based on which process is taking up the CPU.
Thanks,
Josh |