topic Application perfromance in QlikView

Application perfromance

brindlogcool — Fri, 16 Dec 2011 19:08:51 GMT

Hi,

As per the Application optimization technique Count( Distinct ‘FieldName’) will have impact in performance. It will have the impact even if i use this in the conditional show of the object.

Application perfromance

isaiah82 — Fri, 16 Dec 2011 19:36:55 GMT

I haven't seen a performance issue using a "count distinct" in a while. Granted, I'm not using massive data sets, but I am thinking I read somewhere once where this isn't as big of an issue as it used to be.

Anyway, you're correct ~ if you're conditionally showing/hiding an object it is being calculated even though you don't see it. For some objects (e.g. charts) this can be worked around by using the same show/hide condition as the Calculation Condition in the object's properties (I basically do this will all of my conditionally shown charts to maintain performance.)

Alternatively; "back in the day" I would use a counter field in a dimension table (where each record has a value of "1" in the counter field) to increase performance vs. count distinct, and sum() on said field instead of count().

-Isaiah

Re: Application perfromance

brindlogcool — Fri, 16 Dec 2011 20:09:18 GMT

Thanks for your response Isaiah Weed, It is there in the performance document. As the function will run on only one cpu even the server multiple cpu cores. Mine is very large dataset. I couldnt find the way to test it out.

Application perfromance

Fri, 06 Jan 2012 17:24:04 GMT

You can get the Memory Stastics from QlikView Document and chek the performance of every individual object.

Other option could be you can keep your Charts Minimized. If an object is minimized it dosent get refereshed with evry selection.

Re: Application perfromance

brindlogcool — Sat, 14 Jan 2012 19:32:06 GMT

Hi Amit,

I have taken the mem statistics. But it is not having the details of the CPU cores only cpu core is used or all the cpu core is used. ideally i want to understand the QVW file using the multithread rather only one thread is used for calculation it will impact the performance.