Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 363
  • Last Modified:

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.
0
raybies
Asked:
raybies
  • 6
  • 4
1 Solution
 
rob_farleyCommented:
Can you add indexes to your database?

Rob
0
 
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
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now