Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Maximum QVX / QVD file size

hi everyone, is there a maximum QVX / QVD size that QV can handle, or is it all down to the filesystem specifications?

thank you!

1 Solution

Accepted Solutions

Re: Maximum QVX / QVD file size

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

Best,

Peter

6 Replies
Not applicable

Re: Maximum QVX / QVD file size

Hi Erik,

Please refer to this blog: http://community.qlik.com/message/401293#401293

Thanks,

Sai

Re: Maximum QVX / QVD file size

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

Best,

Peter

Not applicable

Re: Maximum QVX / QVD file size

Hi Erik,

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.

Thanks,

Sai

Not applicable

Re: Maximum QVX / QVD file size

thank you guys!

feel silly I was not able to find that post.

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.

But according to all this info, we are good to go for the next two years   ..should be no more than 35GB after this point of time!

thanks!

Not applicable

Re: Maximum QVX / QVD file size

35GB is pretty small Erik. You could happily continue for more years In case of any data issues, try to upgrade your RAM with load balancer or cluster servers.

Thanks,

Sai

Employee
Employee

Re: Maximum QVX / QVD file size

In my opinion it´s not about how big a QVD can be, but what is the optimal size that can be managed.

There´s some aspects like

1) Time to backup

2) Incremental load can be slower (ex.: a 10Gb QVD, need 10G of reading and plus 10Gb of writing)

Generally I recomend that no QVD exceed 100Mb, so big tables are splitted using a date

Community Browser