Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Thank you Dave.
Do u have any example? How to start?
Two potential ways:
Thank you. After first app with 500 mln you know, how it is important
No worries. Of course your first priority is to get the data model perfect, this just makes things even better.
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
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.