Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody
I have a question about sentences STORE .
I Concatenate three QVD's (10 , 5 and 4 GB) and created a new QVD. In resulted i hoped a QVD around of 20 GB but i get a QVD of 50 GB. The Scrip is correct and the data too.
This is correct? (50GB)
Thanks!
Hi Richard,
Resultant QVD size really depends on nature of your data. Size is dependent on whether your data is loaded as optimized or unoptimized and joins used. If you can explain ur scenario I'll be able to help with some solution.
Hi Richard,
Show to us the script please.
Are you doing any transformations on the data like adding some new fields or joining the tables.
The script is like this...
Thanks a lot
Your script looks like clean and I believe the size of qvd will depend on the no of rows.
Richard,
There are two suggestions based on what I understood...
Hope it helps
If your concatenated tables have very different fields, this issue can shows up.
A QVD is a very specialized file, containing:
1) A XML header in plain text, that describes all fields and another information (Creation Date, qvw filename that stored the qvd, the 'lineage' of your data, and so on)
2) A 'Symbol Table' which stores all different simbols that are present at your data, converted to binary and optimized
3) A indexed compressed colection of rows (one to each row of your raw data)
This 'smart' format is the key feature that leads to very impressive load time when you do an optimized load from a QVD
If you´re original tables have much more columns, this will impact step 3 what can lead to that issue you have noticed
Hi Anjos
I worked for each QVD had the same no of fields and the same kind of data
Now when load the QVD's files i do not have this issue
But the result is the same
You have done 'by hand' what QlikView did by itself.
QVD´s are not so 1:1 proportion, it´s not assured that twice the data, twice the size, it all depends of data