We have a crap DB that's way too slow. Management want a whole bunch of Charts on 1 page... these will take 15minutes for each user.
Redesigning the DB is a no go right now... so I figured I could schedule a component to run the query and save the generated chart/image to a sharepoint image library and then use these for the page.
Problem... I can't seem to find any application/component that will export these easily.
Can anyone recommend and component that will:
Export fancy looking Charts in png/jpg/flash.
Store the chart metadata.
Be able to run from a cmd line or C# console app.
The plan was to write a console app that would very hour call the "Component", the component would then execute the stored procs with parameter passed from the console app.
The component would then generate a Flash or Image file and the console app would copy it in to a SharePoint library.