Qlik Community

QlikView Documents

Documents for QlikView related information.

Best Practices for Optimizing

Not applicable

Best Practices for Optimizing

Hi Friends,

     Hope all are doing good. PFA, It refers to explain the best Methods for optimizing. hope this will helps you guys.

Regards

Nirmal

Comments
Not applicable

Hi,

You write that the count(distinct xxx) should be replaced with a sum(Field), field populated during the script. QV 11 seems to be far more efficient now on that topic.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/22/a-myth-about-countdistinct

Did you state the same slowness ?

Fabrice

datanibbler
Esteemed Contributor

Hi,

that first one - the compression_rate when saving - is very interesting. We have had the issue a few times that QlikView was using too much memory on the server. Once it just seemed to run haywire, memory_usage rose to near 100% of available memory ... that is a different issue I'm sure, but the time the server takes to open and reload apps might be relevant nonetheless.

=> Can anyone tell me what will be the effect of a lower compression_rate (set in the user_preferences, right?)? The qvw will take up more space, I guess, but how much?

DataNibbler

P.S.: OK, the size of one app just rose from 900kb to 1MB (data in) when I set the compression to "low" (in the doc_settings, too). How much then will be the "win" effect of that in terms of opening_time (rel.)?

If you turn off or lower the compression, the qvw will occupy more space on disk. It will not affect the RAM usage.

Compression can affect the opening time if the document has to be read from disk. In general, compressed documents will load faster. However, I have seen cases with very large documents where uncompressed opens faster. In that case, the additional CPU required for decompression took longer than additional IO. You would have to test to see if it makes a difference in your case. More here

Qlikview Notes: Document Compression

-Rob

http://masterssummit.com

Version history
Revision #:
1 of 1
Last update:
‎02-04-2014 04:01 AM
Updated by: