Cognos reports executed with dataset output takes 40 sec for the first time

[lalitha.nov20]

Hi All,

I have requirement where in i have to develop the report and report output should be in dataset format. so , we have frame the cognos URL
http://<server>:9300/p2pd/servlet/dispatch/rds/reportData/path/Public Folders/JDABA/Template Reports/VPSC Analytics 8.2/Interface/Hierarchy/Period_Hierarchy_Dev_R2?fmt=DataSet

We have seen a behaviour where in for the first time if i executed this URL it takes time. but after this i execute any report with this URL doesnot take much time.

I have cognos installation on one machine and database on the other machine. I executed this URL from the client machine where i am accessing and developing the reports.

Can any one let me know what would be reason.

Thank you,
Lalitha

[MFGF]

Hi All,

I have requirement where in i have to develop the report and report output should be in dataset format. so , we have frame the cognos URL
http://<server>:9300/p2pd/servlet/dispatch/rds/reportData/path/Public Folders/JDABA/Template Reports/VPSC Analytics 8.2/Interface/Hierarchy/Period_Hierarchy_Dev_R2?fmt=DataSet

We have seen a behaviour where in for the first time if i executed this URL it takes time. but after this i execute any report with this URL doesnot take much time.

I have cognos installation on one machine and database on the other machine. I executed this URL from the client machine where i am accessing and developing the reports.

Can any one let me know what would be reason.

Thank you,
Lalitha

Hi,

The first time you connect to a data source from within Cognos, the Cognos server has to do some work in establishing the connection to the DB server, authenticating with the server, connecting to the DB tables and reading the structure of the required tables as runtime metadata. Once this connection has been established, it is generally help open for a period of time, even if the database is no longer being accessed, so that this overhead is not there subsequently. Eventually the connection pool will time out and after this, the delay will reappear as the connection is re-established.

Cheers!

MF.

[Mfg]

But the case isn't same when you run the report and save the report output. can anyone tell me why is it so please.

                 Thanks in advance.

[MFGF]

But the case isn't same when you run the report and save the report output. can anyone tell me why is it so please.

                 Thanks in advance.

Hi,

When you save a report output, the default action when clicking on the report link is to retrieve and display the saved output rather than connecting to the database, running a query and generating it from scratch. It is obviously much quicker to read and display an output that has already been rendered.

Cheers!

MF.

[Mfg]

  :)Thanks for the reply MF.
Can you please look out for my new post in cognos connection forum.(subject: cognos connection). I got new problem.