Report taking long time to run in PDF format

[kvchow]

Hi all,

I ran the report in HTML format and it is giving the output in 10 minutes and same i ran the report in PDF and it is taking 45 minutes to execute

I am not sure why this much time taking?

As per my knowledge Obviously PDF format taking time but Not that much difference,,but in my case almost 35 min difference,how to convince my user?Is there any IBM documentation is available(PDF format will take time),i want to show my user

Thanks,
Kvchow

[MFGF]

Hi all,

I ran the report in HTML format and it is giving the output in 10 minutes and same i ran the report in PDF and it is taking 45 minutes to execute

I am not sure why this much time taking?

As per my knowledge Obviously PDF format taking time but Not that much difference,,but in my case almost 35 min difference,how to convince my user?Is there any IBM documentation is available(PDF format will take time),i want to show my user

Thanks,
Kvchow

How many pages does your report span? When you render as HTML (interactively) only the first page is initially rendered - so you're not retrieving all the data. If you click the "next page" link, the data for the next page is retrieved then the page is rendered. When rendering as PDF (or Excel or CSV or XML) the whole output is rendered in one go, so all the data has to be retrieved before you can view the output.

MF.

[BigChris]

@MF - Just as an aside - this topic comes up about once a week...do you think it's worth a sticky post that we can refer posters to?

[kvchow]

Hi,

In the report we have 4 pages(Page1,Page2,Page3,Page4),but in the report output we have 50 pages above

Thanks

[Robl]

As the others have said, it's down to the HTML format only returning the first bit of data before it can be displayed, but the PDF version needing to return all the data before creating the PDF.

That said, ten minutes to return the first page and 45 minutes for a 50 page pdf strikes me as VERY slow, even for a complex report.

Have you considered speaking to the DBA or the network team to try and identify a bottleneck?