topic Re: Qlikview desktop memory consumption in QlikView

Qlikview desktop memory consumption

Marcio_Campestrini — Mon, 08 Sep 2014 11:58:36 GMT

I wonder if someone can help me. I have a question.

Recently we have begun to develop some applications that, after charging, are generating qvw files of about 1Gb. When I open these files in Qlikview in my compputador quickly the memory of the machine hits the occupied 11-12Gb (of a total 16Gb).

My question is if this is normal or if there is anything we can do about it. If this scenario is common, we will purchase equipment with 32Gb memory.

I know it's not possible to say exactly the problem and give a solution for this is tricky since you do not have access to the structure, but the idea here is just to understand what may be happening to chart a future planning.

Re: Qlikview desktop memory consumption

ashfaq_haseeb — Mon, 08 Sep 2014 12:00:27 GMT

Hi,

have a look at below posts.

http://community.qlik.com/message/455415#455415

http://community.qlik.com/message/444168#444168

http://community.qlik.com/message/455396#455396

http://community.qlik.com/message/519348#519348

Rest all depends on logic you build. Try to push all logic to backend.

Use 3-tire architecture to build your application.

Make front end application or layer 3 as optimize as you can.

Regards

ASHFAQ

Re: Qlikview desktop memory consumption

avinashelite — Mon, 08 Sep 2014 12:04:26 GMT

Hi,

As we know Qlikview is a In-memory tool, so based on your application size Ram consumption is decided.

In your case its correct, it occupies so much because your app size is more than 1 GB. Try to do performance tuning on your app so that the file size will get reduce.

EG: *Do all the complex calculation in the script.

*Eliminate the unwanted fileds etc

Re: Qlikview desktop memory consumption

shane_spencer — Mon, 08 Sep 2014 12:09:16 GMT

In short the size of a Document in Memory will be roughly 4.25x the size it is on Disk. That does not take in to account any cached results created by user activity.