Performance PDF report Vs Excel Report

[ggreddi]

Hi
I have developed report in cognos 8.2 report studio.
When i run the report in PDF format it has taken 10 Min's time of size 20 MB.
Where as same report i have run in excel foramt it took 57 Min's of size 80 MB.

Recrds are 2 millions only
Can u please guide how i can meet my performance level.

Cheers
GG

[blom0344]

Do you expect anyone to take interest in 20-80 MB management information? These amounts of data are more in the realm of databases, datawarehouses and ETL processes..

[the_xxx]

Both these are high affinity processess...more over I think excel has a limit of 65,536  rows per page....ask your admin to change the settings and try. ..but I agree with BLOM....

[blom0344]

65,536

is the limit for Excel 2002/2003. The latest Excel 2007 version has a much larger capacity, but information is stored in a different format (xlsx).

[the_xxx]

What I feel is , the output of Excel from a cognos will be 2002 format.