topic size of qvd and qvw in QlikView

size of qvd and qvw

yelin_nyu — Mon, 04 Mar 2013 15:14:58 GMT

Hi, I am relatively new to qlikview. But i noticed something recently, qvw is smaller and qvd is larger when both of them contain the same type of data. Why? I know qvd is extremely fast, but why it is so much larger? Thanks

Re: size of qvd and qvw

Mon, 04 Mar 2013 17:12:02 GMT

qvw is a compressed file, much like a zip-file.

qvd is optimized for loading data so it's less or no compression. It also starts with an XML-description of the data.

Re: size of qvd and qvw

Jason_Michaelides — Mon, 04 Mar 2013 17:37:07 GMT

Try zipping up the QVD file - you will see it compresses a lot. As Martin says, it is not compressed at all so it can load faster.

Re: size of qvd and qvw

rwunderlich — Tue, 05 Mar 2013 04:12:27 GMT

Here's some additional information:

http://qlikviewnotes.blogspot.com/2011/03/qlikview-compression.html

-Rob

Re: size of qvd and qvw

Tue, 05 Mar 2013 05:41:28 GMT

Actually, when qvw load data source directly, then this data source store in its memory(RAM).

why we make qvd file?

when qvw load the data source by qvd file, then qvw has capability to compress ( up to 90%) qvd file, then it store in memory . then by this, using less memory than direct load.

so this is the reason,

when both of them contain the same type of data. Then qvd is extremely fast,

Re: size of qvd and qvw

nikhilgarg — Mon, 24 Aug 2015 11:15:04 GMT

hey,

i didn't get what you mean by above statement.

Do you want to say that:

When qvw load data directly from data source then data stored in RAM and when load from qvd then data stored in In Memory. Is it what you wanna say ?