jverasql
asked on
Charting from Oracle database
Hello,
Currently I have several excel templates which query Oracle and are used to update charts. For the smaller files, it works well, but the larger excel files ~100MB's it is quite slow. Does Oracle have something I could use to chart which would help with performance instead Excel?
Currently I have several excel templates which query Oracle and are used to update charts. For the smaller files, it works well, but the larger excel files ~100MB's it is quite slow. Does Oracle have something I could use to chart which would help with performance instead Excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could also try APEX. It comes with a wide variety of charting options.
For free versions of preparing charts, you can try your queries with google chart apis
sample reference of how to incorporate your queries with google charts can be found here
http://www.pythian.com/blog/google-charts-for-dba-tablespaces-allocation/
sample reference of how to incorporate your queries with google charts can be found here
http://www.pythian.com/blog/google-charts-for-dba-tablespaces-allocation/
But a way to help you would be to see if the size of those files can be reduced.
Maybe the queries (that produce the files) could do more of the needed number crunching?