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! :)