How to erase the cache ?

[sanchoniathon]

Hi,

I run this report and takes me 1 minute of processing time.
I re-Run the same report a second time and now it takes only 5 seconds ... I heard it is because of the cache.
I need to make tests on this report in order to reduce the report processing time from 1 min to half that time if possible.

For that i need to know the REAL execution time when the users executes the report for the FIRST time. For the moment i am the only person using the report.

QUESTION: HOW TO ERASE THE CACHE ? WHERE and how ? I need to erase it after each execution.

Thanks !

[kolonell]

I think killing the BIBusTKServermain.exe processes should do the trick. They'll get recreated/respawned as soon as you try to run a new report anyway

[sanchoniathon]

Thanks.

I found out on another cognos forum that i can simply se to "NO" the query "Use Local Cache" property on my report.

This seems to be working for me.

See ya !

[kolonell]

hehe, Yes that would indeed be the preferred method of doing it ;-)

... I should start thinking more along lines of the actual Cognos Product functionality ...