Schedule Chart Image Creation from SQL

Hi.

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.

Any ideas?

Thanks.
LVL 16
raybiesAsked:
Who is Participating?
 
rob_farleyCommented:
Or... you could schedule the reports to run ahead of time and render from a snapshot. That way, the data for the charts will be ready to go.

Rob
0
 
rob_farleyCommented:
Can you add indexes to your database?

Rob
0
 
raybiesAuthor Commented:
Changes to the DB aren't an option... I really just need images. Running reports isn't an option either.

This will be a fairly high volume site, and they want an iphone like ui.

Thanks.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
rob_farleyCommented:
Ok... what about using subscriptions to export a report (containing a chart) as a TIFF image to a file share? Then you access them however you like.

Rob
0
 
raybiesAuthor Commented:
I need to write a fairly complicated console app that connects to sharepoint.

Basically we have > 100 sites. They want a comprehensive dashboard for each site.

SSRS really won't cut it.

console app > charting component > sharepoint library

If there isn't a charting app that I can use, I may just make my own.
0
 
rob_farleyCommented:
Try looking into Dundas. If you can cache the data for each chart, they should respond quickly enough.

Rob
0
 
raybiesAuthor Commented:
None of Dundas stuff will do what I want.
If I missed something please explain how to achieve it.
0
 
rob_farleyCommented:
Well, you may have to write your own then. Do the ComponentArt charting tools have an API you can use to export the images?

Rob
0
 
raybiesAuthor Commented:
No... ChartFX is the closest but again there doesn't seem to anything u can run in the background.
0
 
rob_farleyCommented:
:( Ok.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.