topic Re: Maximum QVX / QVD file size in QlikView https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509495#M687457 <HTML><HEAD></HEAD><BODY><P>In my opinion it´s not about how big a QVD can be, but what is the optimal size that can be managed.</P><P>There´s some aspects like</P><P>1) Time to backup</P><P>2) Incremental load can be slower (ex.: a 10Gb QVD, need 10G of reading and plus 10Gb of writing)</P><P></P><P>Generally I recomend that no QVD exceed 100Mb, so big tables are splitted using a date</P></BODY></HTML> Fri, 29 Nov 2013 16:54:52 GMT Clever_Anjos 2013-11-29T16:54:52Z Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509489#M687450 <HTML><HEAD></HEAD><BODY><P>hi everyone, is there a maximum QVX / QVD size that QV can handle, or is it all down to the filesystem specifications?</P><P></P><P>thank you!</P></BODY></HTML> Fri, 29 Nov 2013 15:42:22 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509489#M687450 2013-11-29T15:42:22Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509490#M687451 <HTML><HEAD></HEAD><BODY><P>Hi Erik,</P><P></P><P>Please refer to this blog: <A _jive_internal="true" href="https://community.qlik.com/message/401293#401293">http://community.qlik.com/message/401293#401293</A></P><P></P><P>Thanks,</P><P>Sai </P></BODY></HTML> Fri, 29 Nov 2013 15:49:30 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509490#M687451 2013-11-29T15:49:30Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509491#M687452 <HTML><HEAD></HEAD><BODY><P>Filesystem specs (64-bit filesystem?) AND available RAM. You may be able to store a file of a few terabytes, but it may not load in 1 GByte of RAM. That's not a limitation of a QVX/QVD file, but it's a limit on what "QV can handle".</P><P></P><P>Best,</P><P></P><P>Peter</P></BODY></HTML> Fri, 29 Nov 2013 15:51:29 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509491#M687452 Peter_Cammaert 2013-11-29T15:51:29Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509492#M687453 <HTML><HEAD></HEAD><BODY><P>Hi Erik,</P><P></P><P>If your Ram size is 256MB, QV can load data upto 2TB. As you upgrade the RAM memory, the capacity increases. There are no limitations from QV as such, it all depends on your RAM size. </P><P></P><P>Thanks,</P><P>Sai</P></BODY></HTML> Fri, 29 Nov 2013 15:54:56 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509492#M687453 2013-11-29T15:54:56Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509493#M687454 <HTML><HEAD></HEAD><BODY><P>thank you guys!</P><P></P><P>feel silly I was not able to find that post.</P><P></P><P>My fears are sparkling from a QVX where I am storing some stock data and in almost a month time reached already 1.300.000 KB.</P><P>But according to all this info, we are good to go for the next two years <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />&nbsp; ..should be no more than 35GB after this point of time!</P><P></P><P>thanks!</P></BODY></HTML> Fri, 29 Nov 2013 16:04:22 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509493#M687454 2013-11-29T16:04:22Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509494#M687455 <HTML><HEAD></HEAD><BODY><P>35GB is pretty small Erik. You could happily continue for more years <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> In case of any data issues, try to upgrade your RAM with load balancer or cluster servers. </P><P></P><P>Thanks,</P><P>Sai</P></BODY></HTML> Fri, 29 Nov 2013 16:07:22 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509494#M687455 2013-11-29T16:07:22Z Re: Maximum QVX / QVD file size https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509495#M687457 <HTML><HEAD></HEAD><BODY><P>In my opinion it´s not about how big a QVD can be, but what is the optimal size that can be managed.</P><P>There´s some aspects like</P><P>1) Time to backup</P><P>2) Incremental load can be slower (ex.: a 10Gb QVD, need 10G of reading and plus 10Gb of writing)</P><P></P><P>Generally I recomend that no QVD exceed 100Mb, so big tables are splitted using a date</P></BODY></HTML> Fri, 29 Nov 2013 16:54:52 GMT https://community.qlik.com/t5/QlikView/Maximum-QVX-QVD-file-size/m-p/509495#M687457 Clever_Anjos 2013-11-29T16:54:52Z