Ireport taking too much time (performance issue)

[neetikamittal]

Hi friends,

I report is taking too much of time to generate a html report that I am worried wat will be the real performance when I will try to run it on real production environment.

Now I am generating a report with app. 5000 records and it is taking 10 minutes.

So can anybody suggest me about how to increas the performance .

wat I need to do.

I read it somewhere that due to antivirus installation on PC makes it too slow.

 

But can anybody tell me how much time it will take in general to generate a report of 5000 records in html format.

 

Thanks

[Giulio Toffoli]

You can do a test by your self:

 

create a blank report, put something into the detail band, press "Run (using an empty datasource)" holding the SHIFT key, set the number of empty records to use to 5000, and you'll get a 5000 records report.

 

Here is the result on my machine:

 

Compiling to file... C:JasperSofttestsforum_samplesr5000.jasper -> C:JasperSofttestsforum_samplesReport_senza_nome_1.java

it.businesslogic.ireport.ReportClassLoader@45ce28

Compilation running time : 190

Filling report...

Locale: English (United States)

Time zone: default

Ignoring pagination

Report fill running time : 1002 (pages generated: 1)

Exporting HTML to file... C:JasperSofttestsforum_samplesr5000.html

Export running time : 470

Executing: C:Program FilesInternet ExplorerIEXPLORE.EXE C:JasperSofttestsforum_samplesr5000.html

 

The generated file is attached [file name=r5000.zip size=24991]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/r5000.zip[/file]

[Giulio Toffoli]

Please note:

 

190 and 470 are milliseconds.

 

 

Giulio

[Code_Slave]

how long is a piece of string?

 

 

1. it depends on the source of your records.

2. how complex is the query.

3. speed of your computer

4. loading of your computer.

 

for example I have 1 query that's about 2,000 records & it takes 4 minutes, to query & generate a pdf.

 

The pdf is just 1 row =1 record* 2,000

 

but I can also get the timings that Giulio gets, using simple data.

 

Now whenever i run a report I crack open a progressbar window.