Generate many (million) reports ? Is it possible?

Hello,
is it possible to generate many reports in BIRT ?
I mean with "many": more than one million.

Is there anyone who test it ?
How long does it take?

Find more posts tagged with

Comments

CBR

Hi,

yes we already had a project that generated millions of reports. There is no way to tell you how long it will take because it heavily depends on the report itself.
One can say that BIRT can deployed as a service on multiple machines. You can now built some kind of reporting cluster using message queue systems (if it's not fast enough just keep adding more machines to the reporting cluster). In such a scenario the only bottleneck can be your database server.
When generating such a massive amount of reports just make sure that you use a database connection pool in your application (otherwise BIRT will just create a new database connection for every report run)

internet

Hello,
I want only integrate charts in my report.
For example I want the volume of sales of a single customer show in a chart.
What do you think how long does it work for generate one report ?

OT:
How can I send you an PM here ?

internet

<blockquote class='ipsBlockquote' data-author="'internet'" data-cid="84542" data-time="1319635714" data-date="26 October 2011 - 06:28 AM">
Hello, 
I want only integrate charts in my report. 
For example I want the volume of sales of a single customer show in a chart. 
What do you think how long does it work for generate one report ? 
 
OT: 
How can I send you a PM here ? </blockquote>

CBR

Hi internet,

you can get quite a good feeling of how long it takes if you are doing some performance tests on a low amount of report runs. We started testing by just using a single PC. We have your own BIRT report generator application that is using the report engine api (not a big deal...it is just calling the report engine api) and simply took a sample report which we generated 20 000 times on this machine. After that we could easily say how long it will take to generate it 1 000 000 times.
Please have in mind that the speed depends on
a) database server specification and network latency to the server

usage of a database connection pool (it will be much faster when using one)
c) the machine on which you run the report engine api
d) the report itself

(also note that the points are not ordered...so a doesn't mean that it has the most impact on performance)

Concerning PM:
I once thought that it was possible to sent a PM to other users, but i couldn't figure out how to do it myself. I made my email visible for you (so you can simply send me a email by using the link in my profile). In addition there should by my skype and msn visible now.