QVD size is greater than csv

[#1]

Hi,

I am using a csv of 294 mb and converting it into qvd, but the size of my QVD is 310 Mb. how this is possible?

how to reduce size of CSV data after creatinf qvd file.

Thanks,

Piyush Jain

[shawn-qv]

It's hard to say without knowing what you've done in your script to create the QVD file.

S.

[JonnyPoole]

If you load the QVD into a QVW and save the QVW, what is the file size ? 

QVD stores data as below according to the help  ( but i'm not 100% sure they are actually compressed). The QVW is compressed (typically 60-80% but dependant on actual unqueness in the data ... as long as you have compression=high or medium which is a default setting) .

------------------------------------------------------------------------------------------

A QVD file holds exactly one data table and consists of three parts:

1. A well formed XML header (in UTF-8 char set) describing the fields in the table, the layout of the subsequent information and some other meta-data.
2. Symbol tables in a byte stuffed format.
3. Actual table data in a bit-stuffed format. 

[marcus_sommer]

A qvd is designed for speeding loads not for saving space. Therefore the file-size is often nearly the same like the source-file. To reduce the file-size from your csv files you could zip them  - have a look here: http://community.qlik.com/search.jspa?q=execute+zip.

- Marcus