Performance Tune QlikSense Application

[neha_sharma1275]

There is an application which takes some 10 seconds to render when I first open the application how can i performance tune it ?

This has only 2M records but is very slow.

Please suggest some steps to improve performance.

(we want no changes at script level)

Is there a way I can look where exactly the bottleneck is in the application

[bramkn]

Without script changes, how do you expect to improve performance other than changing hardware or the data source?

[neha_sharma1275]

I meant  the application takes too long when loaded for the first time itself, can that be tuned, not necessarily a script change there.

[bramkn]

A slow app may be caused by calculations and things like IF statements in the sheets.

To suggest any tuning we need more information.

If you use a lot of IF statements check if they can be substituted for Set analysis.

A lot of performance tuning can be done within the script. So why don't you want script changes?

[neha_sharma1275]

This is the app. It's just 6.5 MB but still take 10 seconds to load for the first time . (2nd sheet FAST TRADE JOURNAL) takes longer

[neha_sharma1275]

Yeah .. that's true Bram. I have however attached the application in the original post. It would be great if you could have a look and suggest.

For now, I am dealing with a faster rendering when the application is launched for the first time

[bramkn]

I've taken a look. It isn't slow for me. I do see you are using extensions? This might be what is causing the slowness.

I also noticed that You have really big tables. This isn't a problem for my pc but might be for yours.

There is nothing else I can do to help. goodluck

[neha_sharma1275]

Yes, extensions are used in this.

BTW what's the specification of your system? just wondering is try to open the app in that and that makes it render faster. And how much time it took for you when you opened the application?

Which table are you specifically pointing to - Big tables?

Also, I am not we versed with QlikSense so it might sound silly.. but can creating QVDs fo the whole data set and using those QVDs would help here.. instead of direct DB connection and Data Pull