topic Re: QVD size is bigger than RAM size in QlikView https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620211#M1112728 <HTML><HEAD></HEAD><BODY><P>Hi Shan,</P><P></P><P>you could limited the amount of records or load a subset of fields only to the smaller memory. You could also try to aggregate the data if you do not need this level of detail. However, there are some tips how to reduce the size. One is to prevent to load fields with high cardinality (IDs, timestamps etc.).</P><P></P><P>- Ralf</P></BODY></HTML> Sat, 22 Feb 2014 13:18:51 GMT rbecher 2014-02-22T13:18:51Z QVD size is bigger than RAM size https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620209#M1112726 <HTML><HEAD></HEAD><BODY><P>Hi experts...</P><P>i faced on of the scenario that my QVD file size is bigger than my RAM size.</P><P></P><P>Example: My QVD size is 5GB but my RAM Size is Only 4GB. how i load the qvd into my RAM is there any method to compress the QVD siz.</P></BODY></HTML> Sat, 22 Feb 2014 11:00:53 GMT https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620209#M1112726 2014-02-22T11:00:53Z Re: QVD size is bigger than RAM size https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620210#M1112727 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 22 Feb 2014 12:29:30 GMT https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620210#M1112727 2014-02-22T12:29:30Z Re: QVD size is bigger than RAM size https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620211#M1112728 <HTML><HEAD></HEAD><BODY><P>Hi Shan,</P><P></P><P>you could limited the amount of records or load a subset of fields only to the smaller memory. You could also try to aggregate the data if you do not need this level of detail. However, there are some tips how to reduce the size. One is to prevent to load fields with high cardinality (IDs, timestamps etc.).</P><P></P><P>- Ralf</P></BODY></HTML> Sat, 22 Feb 2014 13:18:51 GMT https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620211#M1112728 rbecher 2014-02-22T13:18:51Z Re: QVD size is bigger than RAM size https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620212#M1112729 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>A 1GB .qvw document uses around 4GB in RAM for the first user (based on a multiplier of 4x to establish the initial RAM footprint based on file size). This multiplier is normally between 2x and 10x. User number two may increase this by around 10% as their calculations get cached resulting in a required RAM footprint of 4.4GB. User number 3 requires a further 10%, increasing the footprint to 4.8GB, and so on.</P><P></P><P>Please refer the white paper i have attached...</P><P>Hope this helps...</P><P></P><P>-Sundar</P></BODY></HTML> Sat, 22 Feb 2014 18:57:44 GMT https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620212#M1112729 sundarakumar 2014-02-22T18:57:44Z Re: QVD size is bigger than RAM size https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620213#M1112730 <HTML><HEAD></HEAD><BODY><P><BR />Hi Sundar,</P><P></P><P>The document you attached is very useful for the guys who are new to qlikview. Thanks for sharing <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 27 Jun 2014 07:17:08 GMT https://community.qlik.com/t5/QlikView/QVD-size-is-bigger-than-RAM-size/m-p/620213#M1112730 Anonymous 2014-06-27T07:17:08Z