Long Run Time

[pammassey]

Gurus:
I have a report that consists of 3 pages.  All 3 pages run off the same unioned query.  That query takes 10-15 seconds to run, and each report page, run separately, takes 10-15 seconds.  However, when the report is run as a whole, it takes 45 seconds.  This is an unacceptable performance time.  Is there any way to speed up the report or maybe force the pages to run concurrently?

[New_Guy]

Hi,
No offence, if you have 3 report pages and if it is taking 45 seconds, I wouldn't complain about that. How many queries are creating the queries that are making up the union query and how much is the result set that they have to filter in total, if each report page has a different result set based on the criteria it can take 45 seconds. And what is the output format?
Good luck
New guy

[dougp]

How long do the queries take when run directly against the database (not through Cognos)?

How many records on each "page" of output?

Just trying to narrow down the problem.  For example, I have queries that run in a few seconds on the database server, then Cognos takes 30 minutes to render the report.

[MFGF]

The other point to mention is that the description of the problem seems entirely logical. You have three pages, each utilising a query, and the query takes 15 seconds to run. That means the query is executed three times, giving a total of 45 seconds. You might be able to get Cognos to utilise cached data from running the query initially if you're lucky, which might improve performance? Take a look at the following technote:

http://www-01.ibm.com/support/docview.wss?uid=swg21344305

Cheers!

MF.