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...
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
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.