topic Re: Find where perf issue in QlikView

Find where perf issue

surajap123 — Mon, 23 Jun 2014 11:25:30 GMT

Hi All,

What is the approach i should follow to find what is actually causing the performance issue.

I will give some background. I have a dashboard(build by someone) which is

-around 500MB size

-some millions of rows

-20 tabs

-lot of charts(straight, pivot, bar, line, combo charts) in each sheet.

Few charts are visible to the users based on selections made in list box values.

The main issue is when i click on any tab, it takes approx 5-10 seconds to open the tab and approx 10-15 seconds to load all charts.

I want to make the dashboard in such a way that it opens tab and charts open in just 1-3 seconds.

To figure out, where the problem lies while loading charts, i want to strip off various conditions, expressions, objects etc..etc. I am not sure where to start. I mean what is the best steps to figure out where the problem lies??

Re: Find where perf issue

Mon, 23 Jun 2014 11:35:26 GMT

There are several steps you can take to find the issue (or probably issues)

Try the document analyser: http://robwunderlich.com/downloads/

Secondly try to find out which objects use the most memory so you can take the neccesary actions (see http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/28/memory-statistics)

Re: Find where perf issue

shane_spencer — Mon, 23 Jun 2014 12:18:30 GMT

Fewer visisible charts on a Dashboard. The more charts that are visible the longer it takes to render. This is not an issue with server performance rather a design flaw of the QVW. Use containers or minimise / maximise options to have fewer visible charts but still have the ability to show them if needed.

Re: Find where perf issue

Mon, 23 Jun 2014 12:23:07 GMT

Try using

The QlikView Governance Dashboard | Qlik

Without seeing the dashboard check the following

RAM Usage

CPU Usage

Do you have section access

Do you have a lot of users

Do you use a lot of set analysis

Do you have bandwidth restrictions

Re: Find where perf issue

Mon, 23 Jun 2014 12:24:47 GMT

Try to avoid If conditions if u have any in your charts, instead of it use Match(qlikview specific functions).

Mostly if condition takes more time to evaluate.