topic Re: QVD and QVW in QlikView

QVD and QVW

venkey2847 — Fri, 22 Jul 2016 05:39:34 GMT

Hi All,

If i have 500GB data in my source, how much it will reduce in our application ie 1GB or 2GB, How it will reduce the data in qlikview?

what is the process to reduce data in qlikview?

==========================================================

How it will store the data in qvd means which format it can store the data?(Numbers format or CSV format)

and How it will compress the data upto 10 to 90% of data compressed in qvd? how it will do that?

please help me out this issue..

Thanks in advance.

Thanks

Venkey

karthikoffi27se — Fri, 22 Jul 2016 07:38:23 GMT

Hi Venkey,

Usually, it will reduce half of your data size.

So, if your source data is 500GB when you load the data it will reduce it to 250GB in the QVD layer.

The QVD file formats are stored in RAM which are basically Binary formats.

Please have a look at this thread.

Thanks

Karthik

PrashantSangle — Fri, 22 Jul 2016 07:51:36 GMT

Hi,

First of all, QlikView will remove any duplicates of each field creating a symbol table.

Then numeric values are stored into binary form.

There is no the one and only compression ratio. it will greatly depend on your data.

If you've got only unique numbers, you probably won't see any reduction in size, and maybe even a larger QVD.

Regards

avinashelite — Fri, 22 Jul 2016 08:13:36 GMT

check this thread for the complete info