Query Service Caching Administration

Caching reuses previously executed results and, when possible, avoids new queries to the database.

Caching can improve performance when reports are re-run with small modifications, analyses are performed within the same cube, and repetitive master-detail requests are performed for large reports. The cache maintains the security permissions of the user who executes the request.

For more information about how the cache works, see the IBM Cognos 10 Dynamic Query Cookbook in the Cognos® Proven Practices (www.ibm.com/developerworks/data/library/cognos/cognosprovenpractices.html) section of the IBM® website.

Parent topic: Query Service Administration