'Best way to pre-cache large Qlik Sense applications'

[Mccutchan1]

I have several applications that contain 500 million row tables. For a better user experience I would like to pre-cache them.

There are several tools out there to do this but which one is the best?

JMeter
QlikSense.NetSDK
Scalabiltytool
CacheInitializer

[NadiaB]

Hi @Mccutchan1 

Have you seen this post?

https://community.qlik.com/t5/Qlik-Sense-Integration/App-Preload-Qliksense/m-p/1591236

[Mccutchan1]

Thanks DadiaG, I believe I read this but it has been a while. I will go over it again.

[otmane · Accepted solution]

Hi,

You can use the Scalabiltytool package (that's include JMeter and you need to have Java instaled in your machine).

This allow you to cache your app, however i think that the .Net SDK provides more features.

Regards,

Otmane

[Levi_Turner · Accepted solution]

Tool	Pros	Cons	URL / Notes
Scalabilty Tools	Full featured; command line execution possible; a method which people regularly use with Qlik assets	Some configuration complexity	https://community.qlik.com/t5/Qlik-Scalability/Qlik-Sense-Scalability-Tools/gpm-p/1490846
CacheInitializer	Super simple	Lack of flexibility for complex selection states; lack of flexibility for non-Windows authentication	https://github.com/JoeBickley/CacheInitializer
QlikSense.NetSDK	You can do whatever you want to do	You have to build your own approach. The Scalability Tools and the CacheInitializer both use the .NETSDK but in a pre-packaged way
JMeter	?	?	Unsure. Haven't used it with Qlik Sense. Generally speaking tools like JMeter and Load Runner are most commonly used when doing load testing of mashups where the normal Qlik app interactions do not exist.

Since the CacheInitializer is so easy, I'd give it a shot. From there you can get more sophisticated as the need arises.