Cognos report taking 100% of CPU time

[ramprasad]

Hi,

I'm Using 8.4 cognos and developed combo report.

Report details:

1.Report is having 7 sections and with view more link. Each section restricted to display only 5 rows  and if records more than 5 we are enabling the view more link, where user can see all the records for that section.

Properties used:
a).Rows per page:5
b).maximum rows retrieved=6(on query level)
c).Query execution method set to ->concurrent

2.Report runs without any issues for 3 records and hanges for 1lac record which is single day data.

3. process BIBusTKServerMain which is taking more cpu time.


What is the max capacity of cognos reports to retrieve data from db ?

How the property maximum rows retrieved will work ?

Thanks in advance
-Ram

[blom0344]

The larger the set retrieved from the database the more work by the Cognos server engine to format/display the data. Setting maximum rows for a query is something you use for testing a report design. But I do not understand what your problem is really..  Are you concerned that the server is spiking to 100% for a mre 3 seconds?

[ramprasad]

Thank's for your replay.


The issue is resolved , We implemented section with view more option

example: List report we have to show only  5 records and secondly if records are more than or equals to five in list we have to show hyper link to see all the records.

The logic for which is wrong and many duplicate queris getting executed in back end   which is impacting on CPU memory.


Thanks
Ram