Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

neha_sharma1275
New Contributor

Performance Tune QlikSense Application

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

7 Replies
b_knuever
Contributor III

Re: Performance Tune QlikSense Application

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

neha_sharma1275
New Contributor

Re: Performance Tune QlikSense Application

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

b_knuever
Contributor III

Re: Performance Tune QlikSense Application

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
New Contributor

Re: Performance Tune QlikSense Application

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
New Contributor

Re: Performance Tune QlikSense Application

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

b_knuever
Contributor III

Re: Performance Tune QlikSense Application

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
New Contributor

Re: Performance Tune QlikSense Application

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

Community Browser