While Deciding the RAM size Which Qvw size we have to take, Compressed or decompressed...?

[vishalgoud]

Hi Experts,

I have a Qvw file of around 3 GB , 3 GB Size is with Compression Mode as High ( Document Settings - general - Save Format as High )

I just checked the Size of the file With Save Format as - None, it is really shocking that file Size showing around 30 GB ...

now the challenge is RAM size , Based on which Format we have to decide the RAM Size whether Compressed File size i.e 3GB or

File with no Compression ( 30 GB)...

Please Guide us on this issue...

Any response on this post is highly appreciated...

thanks in advance

Regards

Vishal.

[Gysbert_Wassenaar]

See this document: RAM Calculation QlikView App

[Bill_Britt]

Hi,

The old quick rule of thumb is take the compressed size. Below example the QVW is 100mb compressed.

100mb QVW file ( * 4)               400mb Server Memory

10 users 10% of server              400mb Server Memory for user (40 per)

800mb to maintain 1 qvw file

Bi;;

[vishalgoud]

thanx Bill , ur info is helpful

We are also planning the Same Rule for RAM Size but am in great Confusion on Compression High /None option in Document Settings...

My Basic doubt is which file size I have to consider now to  decide the RAM size  , Compressed Qvw which is around 3GB  or Decompressed qvw which is around 30 GB..

plz provide some Conclusion to this...

Regards

vishal.

[mr_barriesmith]

Hi

From our experience, the uncompressed QVW is very close to the size of the Virtual DB in RAM.  So all sizing should be done on the uncompressed size.

The general rule of 1 user used 10% of Virtual DB RAM is reasonable but not for large size QVWs.  If you have a 30GB QVW in RAM it is highly unlikely that an individual user will unpack 3GB RAM through the front-end.

On QlikView Desktop there is a Memory Status button (Document settings, General tab) which we use to look at the big apps.  Qlik say this info is not 100% but we find it reasonable enough for planning.

I'd expect on a 30GB app you would see less than 3% per user.

There are other articles on QlikCommunity on this; sorry I didn't have time to find and refer.

All the best, Adam

[Bill_Britt]

The compress is how it is saved to disk. The options Medium and High substantially decrease the size of the QlikView file while sacrificing some load and save speed.

I have always been tool to use the compress size to determine memory. What you can do is put it on your server check the QlikView Server memory use in task manager and then open the document and see how much memory is used.

Check out the attached PDF.

Bill

[Koniki]

---

@Gysbert_Wassenaar wrote:

See this document: RAM Calculation QlikView App

---

[rwunderlich]

I do not recommend using the old "Rules of Thumb" or the estimator spreadsheet. You can get accurate data per app using WIndows tools or 

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

Document analyzer will give you RAM required for the App as well as per user RAM. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com