If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Can caching be disabled for performance testing ?

Started by hawaii_desperado, 11 Jul 2013 06:35:11 PM

Previous topic - Next topic

hawaii_desperado

I am working on determining the cause of a very slow report.   One problem I am finding is the report takes several minutes for the first run but is instant after the first run due to caching.  This makes it impossible to test changes I am making to improve the performance.  Is there a way to force the report to run without using any cached data?

I have tried Configuration->Query Service Caching->Clear Cache to no avail.

Lynn

There is a property associated with a query called "Use Local Cache" which can be set to No.

longhorndkr

Make sure in Report properties you have it set to Run report as well instead of just Viewing output...  you may not be able to get around the report being cached in your database datasource tho. . .