Data Compression between QlikSense and QlikView

[Arthur_Fong]

Hi all,

I notice something strange when I tried to load the same QVD files into QV and QS.

The qvw file size after loading the QVD files is 30MB, whereas qvf is only 10MB. (3x lesser than QV)

I looked through the post by Henric, but it says both engine are the same

(which means the file size should be the same is it?):

https://community.qlik.com/t5/Qlik-Design-Blog/Symbol-Tables-and-Bit-Stuffed-Pointers/ba-p/1475369/p...

Is there other reasons for these file compression to happen?

Thanks and regards,

Arthur Fong

[Arthur_Fong]

Thanks Brett,

That explains the spikes when we open large qvw files.

However the topic we are discussing here is about the delta of file size between qvf and qvw, loaded with the same qvd.

I would need further explanation on this so that I did not pass the wrong info to my client.

Thanks and regards,
Arthur Fong

[Brett_Bleess]

Let me see if I can get Henric C. to have a look Arthur!  I am pretty sure I am on the right track, but it will be good to know for sure, as I think .qvf is column-based and qvw are row-based still.  Might take a day or two or three for Henric to get to things...

Regards,
Brett

[Arthur_Fong]

Sure Brett,

Thanks for looking into this.

Your help are much appreciated!

[Brett_Bleess]

Arthur, I did find another post in Community from a few years ago that might explain a little more:

https://community.qlik.com/t5/New-to-Qlik-Sense/qvf-file-size-is-half-of-qvw/m-p/840691

Regards,
Brett

[Arthur_Fong]

I did saw this post before opening a new post.

But didn't find it convincing to get a full picture of what is happening behind the scene.