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.
There is a property associated with a query called "Use Local Cache" which can be set to No.
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. . .