topic Disabling Cache in QlikView

Disabling Cache

lblancher — Thu, 08 Jul 2010 17:14:50 GMT

I was wondering if it possible to disable the cache in Qlikview Desktop? I am doing some testing on the amount of time that my chart's take to process and I would like to know worst case scenario. I believe to best way to check this would be to make sure the charts are not using the cache? Does anyone know if this is possible?

Regards,

Lucas Blancher

BizXcel Inc.

Disabling Cache

johnw — Thu, 08 Jul 2010 20:47:31 GMT

I don't know of a way to disable the cache. However, I can think of two ways to CLEAR the cache. First, close down QlikView and bring it up again. Second, run a macro, any macro, since macros clear the cache.

There might be some setting somewhere for how much memory the cache is allowed to use that could be zeroed out.

Disabling Cache

juleshartley — Mon, 20 Sep 2010 12:16:39 GMT

Hi John,

Is this true?... it doesn't seem to affect the cache when I try running a macro...?

I'm investigating performance issues and the caching is making it very difficult!

Thanks

Julian

Disabling Cache

juleshartley — Mon, 20 Sep 2010 12:19:46 GMT

ah, I've answered it - Version 9 doesn't clear the cache on running a macro!

Cheers,
J

Disabling Cache

kji — Mon, 20 Sep 2010 13:04:54 GMT

User Settings, general tab, bottom left corner, try setting cache to 0%.

Disabling Cache

kji — Mon, 20 Sep 2010 13:05:28 GMT

sorry, Bottom Right, not left:)

Disabling Cache

johnw — Mon, 20 Sep 2010 17:38:22 GMT


juleshartley wrote:ah, I've answered it - Version 9 doesn't clear the cache on running a macro!

It doesn't?! Well, that's new! And good (except for cases like this). Wonder how they got around it. Probably better detection for if the macro would invalidate the cache or not. Hmmm.

When I'm testing performance, I generally close down QlikView and bring it back up between every test. Looks like I could save myself some time by fiddling with my cache settings instead. Thanks, Johan.