topic Re: QlikView Performance in QlikView

QlikView Performance

Wed, 07 Aug 2013 06:13:19 GMT

We have a large QV file with 2 billion rows of data (1 year of data)

We observed that QV takes roughly the same time (20-30 seconds) to display 1 year of data vs 1 month of data

If possible, we would appreciate your insights with 2 questions:

-- Q1: It appears that the long running time (20-30 secs) is due to the fact that QV always queries the full data set (1 year) ... even if we only need to display 1 month of data

-- Q2: Is it possible to force QV to only query 1 month of data ... if we only want to display 1 month of data?

Regards.. Khai Le

Cell: 919-730-9899

EMail: kle@powercosts.com

Re: QlikView Performance

jagan — Wed, 07 Aug 2013 06:24:10 GMT

Hi,

Qlikview stores all data into main memory(RAM), so if the file size is less then the calculation would be bit faster, it is better to load only one month data if you don't require the old data.

HOpe this helps you.

Regards,

Jagan.

Re: QlikView Performance

Wed, 07 Aug 2013 06:42:10 GMT

Hi Jagan,

Thanks for your feedback and suggestion!

Our users would like to use QV to display 1 month to 1 year of data (2 Billion rows of data) using the QV drill-down method. Originally, we thought that the QV display time is linear with the volume of data to be displayed using the drill-down method:

-- 1-2 sec to display 1 month of data

-- 6-12 sec to display 6 months of data

-- 12-24 sec to display 1 year of data

Instead, the QV display time is:

-- 15-20 sec to display 1 month of data

-- 15-20 sec to display 6 months of data

-- 15-20 sec to display 1 year of data

It appears that QV always queries the full data set (2 billion rows of data) whether we display 1 month, 6 months, or 12 months of data

What can we do to speed up the QV display time when we only display 1 month of data?

Regards.. Khai Le

Cell: 919-730-9899

EMail: kle@powercosts.com

Re: QlikView Performance

sathishkumar_go — Wed, 07 Aug 2013 06:53:02 GMT

HI Khai Le, For improving the performance, 1) Remove Unwanted fields 2) In expression, use set analysis 3) Avoid IF condition in expression 4) Avoid count function 5) Avoid calculated dimension 6) Use variable in the expression (Example : sum(sales); Instead of sum(sales) in expression, Variable1 = sum(sales) and pass Variable1 in expression 7) remove synthetic keys and circular loop in the QVW Hope this will helpful for you. Regards Sathish