How to improve performance by reusing cached data when running a report

Resolving The Problem

In Report Studio, Query Studio, and Cognos Viewer the results for previous requests to the database are cached for the duration of a session when session caching is enabled. To increase performance, for subsequent queries, Cognos uses cached results for some actions rather than accessing the database. This applies when the same results can be used or when the new results are a subset of the cached results.

However, because performance may be affected, you may want to leave session caching disabled in the following situations:

• Users expect up-to-date results directly from the database for every query, for example new records that were added to the database in the interim.
• You want to limit the number of times the cache is accessed during a session.

1. Rename the cognos_location/configuration/CQEConfig.xml.sample file to CQEConfig.xml.
2. Open the cognos_location/configuration/CQEConfig.xml in an editor.
3. Ensure that your editor supports saving files in UTF-8 format.
4. Find the queryReuse parameter and change the value to desired value, 5 is the default setting. To disable caching, set the value to 0
5. Save the CQEConfig.xml file.
6. Using Cognos Configuration, stop and then restart Cognos.