what is the compression factor in QVD

[#1]

Hi ,

        Anyone please tell me .

Thanks&Regards

Devi

[engishfaque]

Dear Devi,

Here is the compression factor in QVD, please check link,

what is compressing factor of qvd?

Kind regards,

Ishfaque Ahmed

[PradeepReddy]

the bellow link might be helpful in understanding the data storage in QlikView

Symbol Tables and Bit-Stuffed Pointers

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointers

[parthiband]

Normally we say 1:4 of the size.

But that is not true always.

It varies based on the distinct values u have in your source table

[#5]

Hi Durairaj,

                Please tell me in details of size(1:4)

Regards,

Devi

[avinashelite]

Hi Devi,

Qlikview i.e. the .qvw will provide you 10X compression on the data. But the Qvd will not be compressed!! its size is directly depends on the size of the data your having. we can optimize the qvd's not the compression.

Regards,

@vi

[Anonymous]

Hi,

QVD can be optimized or non-optimized but compressed.

[parthiband]

Hi Devi,

Sorry for the delayed reply.

For example if u have a sales data file of 50MB, it can be compressed to 10MB

NOTE: It all depends on the unique values u have in that table

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointers

Read this link.

It will be good!!

Thanks,