Avatar of chshwong
chshwong
 asked on

Alternative to SQL Reporting Services

At our company, we use SQL Reporting Services (2005/2008) to create our reports.
Our software are mostly composed of .Net and Java programming.

The reports normally contain dynamic tables, graphs, and all that you can think of.
We have done everything that we can such as massive denormalization in order to speed up database calls. Now 90% of the process time reside in rendering, and there's nothing much we can do about that right now.

We're at over 3 seconds per report, and we're hoping to achieve 10 reports per second instead. It'll be used for banks, so it can't take days to generate just a million. The final forms need to be in PDF format. They have awesome printers that can print that much in hours.

Please let us know what realistic alternatives we have here.
We can change database, way of programming and even hardware.
We need to achieve:
- 10 reports per second
- Average reports contain 10-20 pages, with dynamic tables and graphs.
- PDF as final form (other alternatives? pictures? with table formatting and graphs in mind)

As a side, what about, some other methods that directly brings report generation to printers?

Your help is greatly appreciated! :)
Microsoft DevelopmentSSRSCrystal Reports

Avatar of undefined
Last Comment
CheeseRogue

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
tickett

It sounds like this is for generating customer reports to be e-mailed / available online / printed.

Is it the same report (or a relatively small set of reports) being run many times with different parameters (i.e. customer id / date?)

The solution may involve using a single report which runs for a range of customer id's starting a new page for each. If printing this is simple- if you need to e-mail / save separate pdf's you'll need to find a way to handle this.

L
CheeseRogue

if you run the reports on their own with a simple export of some sort (not pdf) are you getting the response time you are looking for? If you are, have you considered maybe using a PDF printer instead of an export to pdf?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck