topic Re: Cache Warming in QlikView

Cache Warming

Mon, 26 Jan 2026 18:19:17 GMT

Hi there,

I understand that there is a pre-load functionality in QVS, but is there a feature equivalent to pre-caching or cache-warming? If anyone can point me to the right direction, it would be great.

Thank you.

Re: Cache Warming

dde — Sat, 24 Nov 2012 13:57:23 GMT

There is no feature out of the box like that, no.

I have achieved a similar thing using a copy of QlikView Desktop and the API. Write some VBscript which cycles around some of your common listboxes. It can then be scheduled as a Supporting Task in Publisher following your Reload and Distribution task.

Re: Cache Warming

Mon, 26 Nov 2012 01:54:18 GMT

Thank you Dave.

Re: Cache Warming

Tue, 19 Nov 2013 23:45:40 GMT

Do u have any example? How to start?

Re: Cache Warming

dde — Wed, 20 Nov 2013 04:32:29 GMT

Two potential ways:

Use the VBScript idea as I mentioned. I suggest you get the API Guide:http://community.qlik.com/docs/DOC-2640 .
An alternative is to use the Load Testing tools at http://community.qlik.com/docs/DOC-2705 . Build a script to simulate testing but with a single user. You could then batch run this from Publisher.

Re: Cache Warming

Wed, 20 Nov 2013 05:31:30 GMT

Thank you. After first app with 500 mln you know, how it is important

Re: Cache Warming

dde — Wed, 20 Nov 2013 05:33:34 GMT

No worries. Of course your first priority is to get the data model perfect, this just makes things even better.

Re: Cache Warming

Wed, 20 Nov 2013 05:40:01 GMT

Yeah,

i'am during model perfection. But with this data volume each mutation (all almost clear stars, minimal use of set analysis) without cache response time is on the 30 s. level. With ready cache it is immediately.

Of course i know, that it is impossible to prepare cache with all potential users selection states. I think, cache will be very big, but (using pareto) probably 20% of cache will have 80% important users selections states. And this i why it is important to know, what users will be looking for in your big app.

regards

Darek

Re: Cache Warming

dde — Wed, 20 Nov 2013 08:30:30 GMT

Fair enough. Work out what the primary route most users take (e.g. what listboxes) and then have your script loop around those. You could then schedule this in Publisher to follow your Reload.