topic Re: Vbs script to pre cache selection in QlikView

Vbs script to pre cache selection

SunilChauhan — Fri, 05 Dec 2014 06:22:50 GMT

Hi all,

I have found below attached vbs in best practices and found that it will increase performance using external task in publisher.

but i want to know how to apply the same where to write this code and where we can call this. and also what are the disadvantages of using this

Re: Vbs script to pre cache selection

Gysbert_Wassenaar — Fri, 05 Dec 2014 12:03:07 GMT

As far as I can tell that script does absolutely nothing except waste cpu cycles.

Re: Vbs script to pre cache selection

rajeshvaswani77 — Fri, 05 Dec 2014 12:04:22 GMT

No, script will not increase performance, it can however reduce it.

Re: Vbs script to pre cache selection

mayankraoka — Fri, 14 Sep 2018 12:22:59 GMT

Hi Sunil,

Have you tried to run this for pre-caching & any success for this?

Regards,

Mayank

Re: Vbs script to pre cache selection

Miguel_Angel_Baeyens — Fri, 14 Sep 2018 13:13:21 GMT

Use JMeter and the Scalability Center tools for cache warming. They do work.

Re: Vbs script to pre cache selection

dplr-rn — Fri, 14 Sep 2018 13:38:37 GMT

Agreed. that was going to be my suggestion

Re: Vbs script to pre cache selection

mayankraoka — Fri, 14 Sep 2018 13:52:34 GMT

Hi Miguel thanks for the reply .

Thanks for the reply.but one concern is need to install Jmeter for this.

To double check well the above Vbscript won't work as this will be easy to do?

If not do you have link/document for steps to use jmeter and scalability tools for cache warming?Please share.

Regards,

Mayank

Re: Vbs script to pre cache selection

Miguel_Angel_Baeyens — Fri, 14 Sep 2018 14:00:31 GMT

I don't think there are documents for cache warming specifically, but since it is what the Scalability Tools do by definition, that is, generating load and therefore, caching results, it's a nice side effect.

Yes, you have to install Jmeter in order to use the Scalability Tools for QlikView. And you need Java to be able to run Jmeter.

All the documentation and more in the Qlik Scalability‌ group.

Re: Vbs script to pre cache selection

dplr-rn — Fri, 14 Sep 2018 14:09:18 GMT

not cache warming specifically but documentation on using scalability tool

QV Scalability Tools (QV10,QV11,QV12)