COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sanchoniathon on 03 Aug 2009 09:32:10 AM

Title: How to erase the cache ?
Post by: sanchoniathon on 03 Aug 2009 09:32:10 AM
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 !
Title: Re: How to erase the cache ?
Post by: kolonell on 03 Aug 2009 11:14:38 AM
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
Title: Re: How to erase the cache ?
Post by: sanchoniathon on 03 Aug 2009 01:25:30 PM
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 !
Title: Re: How to erase the cache ?
Post by: kolonell on 03 Aug 2009 01:30:18 PM
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 ...