COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: fry on 03 Nov 2014 03:51:42 PM

Title: Performance - HTML
Post by: fry on 03 Nov 2014 03:51:42 PM
Hi

I am experiencing something I never did before. I have a report that runs in HTML in approx 5 minutes, and if I page down to the end, the whole process takes about 7 minutes from submission.

When I run the same report in the background, HTML or PDF it takes 5 hours ?

Any ideas

Thanks
Title: Performance - HTML
Post by: Lynn on 03 Nov 2014 06:56:12 PM
HTML is always going to fetch just what you need to display the first page. It will fetch more as you page down. This is by design.

When you run for the entire result set it must perform the entire query. Is this a very large result set?


Sent from my iPhone using Tapatalk